You must have single quotes around strings in SQL. sqlstmt = "SELECT * from tbluser WHERE User = '" & strUser & "'"
Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----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 PROTECTED]
