Yes, IN is a reserved word in SQL. You should not have a field with that
name in the table.
Russel Madere, Jr.
Web Developer
"Be good and you will be lonesome.
Be lonesome and you will be free.
Live a lie and you will live to regret it."
Jimmy Buffett
That's What Living Is To Me
-----Original Message-----
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 20, 2000 3: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.
------------------------------------------------------------------------------
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.