RecordSet Help

[zduck]

When I try to run the following code it gives me this error.
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
...., line 41

HERE IS THE CODE (WITH LINE NUMBERS):

36: email = LCase(Request.QueryString("email"))
37: IF email > "" THEN
38: set rs = server.createobject("ADODB.recordset")
39: sql = "SELECT * FROM members WHERE email='" & email & "' AND active<>'true'"
40: Response.Write(sql) 'FOR ERROR CHECKING
41: rs.Open sql,conn
42: IF rs.EOF THEN
43: Response.Write("....")
44: ELSE
..................................................
.............................
...................
..........
....

Can anyone please help me with this.

-Joshua David

[raf]

I'm not shure, buth i think the problems is in line 39
(the error is on line 41 because the sql statement gets called their and is then executed

try replacing 'true' by true

i think your next error will be on line 42 it should be :
if rs.EOF=true then

line 37 also looks a bit weird. do you mean :
IF Len(email) = "0" THEN

[zduck]

Thank You But I Got It Figured Out. I Had Simply Refered To The Wrong Database.

[whammy]

Heh... don't you hate when that happens? ;)