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