thanks everyone for your answers, tired morning and must have neglected the 's
Jon ----- Original Message ----- From: "Chris Janz" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 11:39 AM 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 PROTECTED]
