Where I said, email in the database is defined as text, I meant to say

UserID in the database is defined as text



-----Original Message-----

From: Larry Rosenzweig [mailto:rosenzl@o...]

Sent: Thursday, January 24, 2002 3:36 PM

To: Access ASP

Subject: [access_asp] What is the correct syntax for holdemail in the where

clause?



Please tell me what's wrong with holdemail, in the where clause! email in

the database is defined as text.







Dim holdemail



Set RF=Request.Form 'For Performance



Holdemail = RF("email")







If Not Session("varadmins") = 1 Then

     Set RS = Conn.Execute("Select CustomerID FROM tblCustomers where

CustomerID = " & intCustomerID)

Else

     Set RS = Conn.Execute("Select UserID FROM tblLogons Where UserID = "

& holdemail)



End If



I tried this so many ways. It contains an email address. I know there

should be quotes around it, because it is not numeric. What is the actual

syntax?  The first select statement is fine.







Thanks,







Larry