Brian Gubb
|
| Posted: 10/12/2002, 8:28 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_00C8_01C27271.05F999B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
In Codecharge 2.0 I was able to put the following so the Access 2000 =
dates were recognized.
sWhere=3Dreplace(sWhere, "'" & GetParam("start_date") & "'", "#" & =
GetParam("start_date") & "#")
Where do I put this in CC Studio? Or should I be trying something else =
to recognize the Access 2000 dates?
Brian
------=_NextPart_000_00C8_01C27271.05F999B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>
<P class=3DMsoNormal><SPAN style=3D"FONT-SIZE: 11pt; FONT-FAMILY: =
Arial">In=20
Codecharge 2.0 I was able to put the following so the Access 2000 dates =
were=20
recognized.</SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; FONT-FAMILY: Arial">sWhere=3Dreplace(sWhere, =
"'" &=20
GetParam("start_date") & "'", "#" & GetParam("start_date") & =
"#")</SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"FONT-SIZE: 11pt; FONT-FAMILY: =
Arial">Where do I=20
put this in CC Studio? Or should I be trying something else to recognize =
the=20
Access 2000 dates?</SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 11pt; FONT-FAMILY: =
Arial">Brian</SPAN></P></FONT></DIV></BODY></HTML>
------=_NextPart_000_00C8_01C27271.05F999B0--
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 10/22/2002, 1:29 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0010_01C279BD.FF0E43E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Set Database type in Connection Properties to "MS Access".
--=20
Alex,
Support Engineer
CodeCharge Team
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message =
news:ao9f3e$5gp$1@news.codecharge.com...
In Codecharge 2.0 I was able to put the following so the Access 2000 =
dates were recognized.
sWhere=3Dreplace(sWhere, "'" & GetParam("start_date") & "'", "#" & =
GetParam("start_date") & "#")
Where do I put this in CC Studio? Or should I be trying something else =
to recognize the Access 2000 dates?
Brian
------=_NextPart_000_0010_01C279BD.FF0E43E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Set Database type in Connection Properties to "MS=20
Access".</FONT></DIV>
<DIV> </DIV>
<DIV><BR>-- <BR><BR>Alex,<BR>Support Engineer<BR>CodeCharge =
Team<BR></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> wrote =
in message=20
<A=20
=
href=3D"news:ao9f3e$5gp$1@news.codecharge.com">news:ao9f3e$5gp$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>
<P class=3DMsoNormal><SPAN style=3D"FONT-FAMILY: Arial; FONT-SIZE: =
11pt">In=20
Codecharge 2.0 I was able to put the following so the Access 2000 =
dates were=20
recognized.</SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-FAMILY: Arial; FONT-SIZE: 11pt">sWhere=3Dreplace(sWhere, =
"'" &=20
GetParam("start_date") & "'", "#" & GetParam("start_date") =
&=20
"#")</SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"FONT-FAMILY: Arial; FONT-SIZE: =
11pt">Where do=20
I put this in CC Studio? Or should I be trying something else to =
recognize the=20
Access 2000 dates?</SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-FAMILY: Arial; FONT-SIZE: =
11pt">Brian</SPAN></P></FONT></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0010_01C279BD.FF0E43E0--
|
|
|
|
|
