'password' is reserved, use [password] or rename the field. I expect 'userid' is numeric: sqlstmt = sqlstmt & "WHERE User=" & UserID
----- Original Message ----- From: "Jon Barnhardt" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 03:01 pm Subject: RE: SQL query Today is just not my day for SQL statements Any ideas on the following? sqlstmt = "UPDATE tbluser" sqlstmt = sqlstmt & " SET UserFirst='" & FName & "'," sqlstmt = sqlstmt & "UserLast='" & LName & "'," sqlstmt = sqlstmt & "Password='" & Password & "'," sqlstmt = sqlstmt & "Group='" & Group & "'," sqlstmt = sqlstmt & "Department='" & Depart & "'," sqlstmt = sqlstmt & "Delete='" & Delete & "'" sqlstmt = sqlstmt & "WHERE User='" & UserID & "'" gives the error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement Thanks again Jon>> today -----Original Message----- From: Jon Barnhardt Sent: Tuesday, November 05, 2002 11:44 AM To: ActiveServerPages Subject: RE: SQL query Right you are my friend Thanks Jon -----Original Message----- From: Chris Janz [mailto:chris@;iwebsight.com] Sent: Tuesday, November 05, 2002 11:39 AM To: ActiveServerPages Subject: RE: SQL query need to delimit your text in the SQL query... so you would want it to look like this: sqlstmt = "SELECT * from tbluser WHERE User = '" & strUser & "'" HTH, Chris -----Original Message----- From: Jon Barnhardt [mailto:jon_barnhardt@;educ8.org] Sent: Tuesday, November 05, 2002 11:10 AM To: ActiveServerPages Subject: SQL query I'm doing a SIMPLE query against an access database and for some reason it doesn't like me. here is the statement: sqlstmt = "SELECT * from tbluser WHERE User =" & strUser Here is the error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'User =Chris K'. what gives?? I just can't see it today... Thanks again for the help Jon --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
