Record set problem in ASP

[bexter]

I'm having trouble finding a specific Record in my record set

I've tried using the

recordset.find( ) function (example)
.
.
.

rsProfile.Find ("[Login]" = Session("UserID"))
.
.
.

Where Login is the name of a field in my database and
I'm triing to match it to my session ID

but I keep getting this error:

Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

If anyone could help I would appreciate it -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[prestor]

Hi bexter

I think you might be coming at the problem from the wrong angle. It would be better to build your sql query so that it returns only one record rather than a bunch of records. You can then test whether the the EOF (end of file) property is true for the recordset. If true then nothing was pulled from the database, if false then you have a match and the user exists.

Your SQL statement would look something like this:

sql = "SELECT fieldname1, fieldname2 FROM tablename WHERE Login = '"&Session("UserID")&"'"

Have a good day -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --