simple piece of code - need help

[kmckil.ca4]

tried this:

var RS = Server.CreateObject("ADODB.Recordset");
RS.Open("select * from Tbl_users where EmailName='"+strEmailAddr+"'");

Response.write(RS("UID"));







It didn't work - gave the following error:


ADODB.Recordset error '800a0e7d'

The application requested an operation on an object with a reference to a closed or invalid Connection object.


what am I doing wrong?