I think "IN" might be a reserved word.
HTH
brian
----- Original Message -----
From: Shawn Regan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 20, 2000 3:43 PM
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.
>
------------------------------------------------------------------------------
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.
