I know this must be so easy but I keep getting the wrong output.

I have a LOGIN PAGE, LOGGED IN PAGE and an ACCESS DATABASE.

When you login, a message should come up and say,
"Good evening Mally"

Instead when you login, a message comes up saying,
"Good evening
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/html/search.asp, line 272"

Line 272 reads
<%=(Recordset1.Fields.Item("ChristianName").Value) %>

I have a recordset in the LOGGED IN PAGE,
SELECT ChristianName
FROM tblUsers
WHERE ChristianName = 'MMColParam'
MMColParam 1 Session("ChristianName")

In the login page I have no recordset. All I have is the 'User Authentication LOGIN USER'.

Any suggestions?

Same advice as previous posts:

Use Response.Write(myRecordset.Source) and diagnose the resulting SQL statement.

I think you're querying again for the text 'MMColParam' and not for that variable's value.

Cheers,

Imar

Yes thats true.

Did try, came up with this.

Microsoft VBScript compilation error '800a0401'
Expected end of statement
/html/search.asp, line 53
Response.End()Recordset1.CursorType = 0
--------------^

Can you suggest what it may be?

Mally.

Does the error message not give you a clue?

Response.End()Recordset1.CursorType = 0

Should be on two lines....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.