This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFAB0E.1741B0E0
Content-Type: text/plain;
charset="iso-8859-1"
I found it it was the reserved word IN :)
Shawn Regan
-----Original Message-----
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 20, 2000 1:43 PM
To: '[EMAIL PROTECTED]'
Subject: can anyone see anything wrong with this?
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFAB09.1517DF80
Content-Type: text/plain;
charset="iso-8859-1"
Anyone see anything wrong with this?
SQL = "UPDATE CARD SET OUT='7:00' WHERE EMP_ID='5955' AND DATE='04/19/00'
AND IN='9:00'"
ERROR BEWLOW
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'EMP_ID='5955' AND DATE='04/19/00' AND IN='9:00''.
SQL = "UPDATE CARD SET OUT='7:00' WHERE EMP_ID='5955' AND DATE='04/19/00'
AND IN='9:00'"
TIA
Shawn Regan
------_=_NextPart_001_01BFAB09.1517DF80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>can anyone see anything wrong with this?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Anyone see anything wrong with this?</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>SQL =3D "UPDATE CARD SET OUT=3D'7:00' WHERE =
EMP_ID=3D'5955' AND DATE=3D'04/19/00' AND IN=3D'9:00'"</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>ERROR BEWLOW</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Error Diagnostic Information</FONT>
<BR><FONT SIZE=3D2>ODBC Error Code =3D 37000 (Syntax error or access =
violation)</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>[Microsoft][ODBC Microsoft Access Driver] Syntax =
error (missing operator) in query expression 'EMP_ID=3D'5955' AND =
DATE=3D'04/19/00' AND IN=3D'9:00''.</FONT></P>
<BR>
<P><FONT SIZE=3D2>SQL =3D "UPDATE CARD SET OUT=3D'7:00' WHERE =
EMP_ID=3D'5955' AND DATE=3D'04/19/00' AND IN=3D'9:00'"</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>TIA</FONT>
<BR><FONT SIZE=3D2>Shawn Regan</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01BFAB09.1517DF80--
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------_=_NextPart_001_01BFAB0E.1741B0E0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: can anyone see anything wrong with this?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>I found it it was the reserved word IN :)</FONT>
</P>
<P><FONT SIZE=2>Shawn Regan</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Shawn Regan [<A
HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, April 20, 2000 1:43 PM</FONT>
<BR><FONT SIZE=2>To: '[EMAIL PROTECTED]'</FONT>
<BR><FONT SIZE=2>Subject: can anyone see anything wrong with this?</FONT>
</P>
<BR>
<P><FONT SIZE=2>This message is in MIME format. Since your mail reader does not
understand</FONT>
<BR><FONT SIZE=2>this format, some or all of this message may not be legible.</FONT>
</P>
<P><FONT SIZE=2>------_=_NextPart_001_01BFAB09.1517DF80</FONT>
<BR><FONT SIZE=2>Content-Type: text/plain;</FONT>
<BR> <FONT
SIZE=2>charset="iso-8859-1"</FONT>
</P>
<P><FONT SIZE=2>Anyone see anything wrong with this?</FONT>
</P>
<BR>
<P><FONT SIZE=2>SQL = "UPDATE CARD SET OUT='7:00' WHERE EMP_ID='5955' AND
DATE='04/19/00'</FONT>
<BR><FONT SIZE=2>AND IN='9:00'"</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>ERROR BEWLOW</FONT>
</P>
<BR>
<P><FONT SIZE=2>Error Diagnostic Information</FONT>
<BR><FONT SIZE=2>ODBC Error Code = 37000 (Syntax error or access violation)</FONT>
</P>
<BR>
<P><FONT SIZE=2>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in</FONT>
<BR><FONT SIZE=2>query expression 'EMP_ID='5955' AND DATE='04/19/00' AND
IN='9:00''.</FONT>
</P>
<BR>
<P><FONT SIZE=2>SQL = "UPDATE CARD SET OUT='7:00' WHERE EMP_ID='5955' AND
DATE='04/19/00'</FONT>
<BR><FONT SIZE=2>AND IN='9:00'"</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>TIA</FONT>
<BR><FONT SIZE=2>Shawn Regan</FONT>
</P>
<P><FONT SIZE=2>------_=_NextPart_001_01BFAB09.1517DF80</FONT>
<BR><FONT SIZE=2>Content-Type: text/html;</FONT>
<BR> <FONT
SIZE=2>charset="iso-8859-1"</FONT>
<BR><FONT SIZE=2>Content-Transfer-Encoding: quoted-printable</FONT>
</P>
<P><FONT SIZE=2><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML
3.2//EN"></FONT>
<BR><FONT SIZE=2><HTML></FONT>
<BR><FONT SIZE=2><HEAD></FONT>
<BR><FONT SIZE=2><META HTTP-EQUIV=3D"Content-Type"
CONTENT=3D"text/html; =</FONT>
<BR><FONT SIZE=2>charset=3Diso-8859-1"></FONT>
<BR><FONT SIZE=2><META NAME=3D"Generator" CONTENT=3D"MS Exchange
Server version =</FONT>
<BR><FONT SIZE=2>5.5.2650.12"></FONT>
<BR><FONT SIZE=2><TITLE>can anyone see anything wrong with
this?</TITLE></FONT>
<BR><FONT SIZE=2></HEAD></FONT>
<BR><FONT SIZE=2><BODY></FONT>
</P>
<P><FONT SIZE=2><P><FONT SIZE=3D2>Anyone see anything wrong with
this?</FONT></FONT>
<BR><FONT SIZE=2></P></FONT>
<BR><FONT SIZE=2><BR></FONT>
</P>
<P><FONT SIZE=2><P><FONT SIZE=3D2>SQL =3D &quot;UPDATE CARD SET
OUT=3D'7:00' WHERE =</FONT>
<BR><FONT SIZE=2>EMP_ID=3D'5955' AND DATE=3D'04/19/00' AND
IN=3D'9:00'&quot;</FONT></FONT>
<BR><FONT SIZE=2></P></FONT>
<BR><FONT SIZE=2><BR></FONT>
<BR><FONT SIZE=2><BR></FONT>
</P>
<P><FONT SIZE=2><P><FONT SIZE=3D2>ERROR BEWLOW</FONT></FONT>
<BR><FONT SIZE=2></P></FONT>
<BR><FONT SIZE=2><BR></FONT>
</P>
<P><FONT SIZE=2><P><FONT SIZE=3D2>Error Diagnostic
Information</FONT></FONT>
<BR><FONT SIZE=2><BR><FONT SIZE=3D2>ODBC Error Code =3D 37000 (Syntax
error or access =</FONT>
<BR><FONT SIZE=2>violation)</FONT></FONT>
<BR><FONT SIZE=2></P></FONT>
<BR><FONT SIZE=2><BR></FONT>
</P>
<P><FONT SIZE=2><P><FONT SIZE=3D2>[Microsoft][ODBC Microsoft Access
Driver] Syntax =</FONT>
<BR><FONT SIZE=2>error (missing operator) in query expression 'EMP_ID=3D'5955' AND
=</FONT>
<BR><FONT SIZE=2>DATE=3D'04/19/00' AND IN=3D'9:00''.</FONT></P></FONT>
<BR><FONT SIZE=2><BR></FONT>
</P>
<P><FONT SIZE=2><P><FONT SIZE=3D2>SQL =3D &quot;UPDATE CARD SET
OUT=3D'7:00' WHERE =</FONT>
<BR><FONT SIZE=2>EMP_ID=3D'5955' AND DATE=3D'04/19/00' AND
IN=3D'9:00'&quot;</FONT></FONT>
<BR><FONT SIZE=2></P></FONT>
<BR><FONT SIZE=2><BR></FONT>
<BR><FONT SIZE=2><BR></FONT>
</P>
<P><FONT SIZE=2><P><FONT SIZE=3D2>TIA</FONT></FONT>
<BR><FONT SIZE=2><BR><FONT SIZE=3D2>Shawn Regan</FONT></FONT>
<BR><FONT SIZE=2></P></FONT>
</P>
<P><FONT SIZE=2></BODY></FONT>
<BR><FONT SIZE=2></HTML></FONT>
<BR><FONT SIZE=2>------_=_NextPart_001_01BFAB09.1517DF80--</FONT>
<BR><FONT
SIZE=2>------------------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>Archives: <A HREF="http://www.eGroups.com/list/cf-talk"
TARGET="_blank">http://www.eGroups.com/list/cf-talk</A></FONT>
<BR><FONT SIZE=2>To Unsubscribe visit <A
HREF="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
TARGET="_blank">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</A>
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01BFAB0E.1741B0E0--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
