Hi,



The code below returns the following error,

"Syntax error (missing operator) in query expression 'Email

=poh@v...'. "



set objRS = Server.CreateObject ("ADODB.Recordset")

objRS.Open "SELECT * FROM tblUser WHERE Email =" & strEmail, _

   strConnect, adOpenForwardOnly, adLockReadOnly, adCmdtext



My guess is that when I use the WHERE statement to limit with a string you

need to use a single quotes around the string.  For example - the SQL

statement should look like: WHERE Email = 'strEmail'  However, how does

one pass single quotes around a string variable?



Any suggestions would help.

thanks in advance.

Nevermind, I figure this out from a previous post.



thanks anyway.