试试这两个办法:
1、strSQL="select * from Person where EMailAddress="&strEMail
2、strSQL="select * from Person where EMailAddress=' " & strEMail & " ' "不变,改rsUsers.Open strSQL, objConn为rsUsers.Open strSQL, objConn,3,3
dim rsUsers
set rsUsers=Server.CreateObject("ADODB.Recordset")
strSQL="select * from Person where EMailAddress=' " & strEMail & " ' "
rsUsers.Open strSQL, objConn
这个是我的源程序