Try "SELECT * from tbluser WHERE User = '" & strUser & "'"
You need to quote that string value. -- Bill >-----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]
