what is wrong-what do i do

[mdavid87]

Hi, I am trying to make a registration page for my site and every time I try to view it in my local host i get this

Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/1080design/registration.asp, line 163


I thought I created it right, but I dont Know-I know its probably simple, but can some one help me and explain to me what i need to do to fix this and get my registration page working.

Thanks
Mark

[D3mon]

Looks like your recordset is empty and you tried to do something with it. Check your query is actually returning something.

[mdavid87]

can you expand on that-im still confused not sure what you mean. For instance what should I look at exactly. Im still new to this stuff.

Thanks
Mark

[mdavid87]

This is what i get. What does this mean-I am so confused. Please Help if you can!


Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/1080design/registration.asp, line 163

Thanks
Mark

[benbacardi]

for your first problem....

presumably you are connecting to a database, and trying to output results?

before you can output anything, you need to check the database has actually returned something. you can do this by using ASPs built in EOF function. EOF means End of File. If you are opening a recordset, and then outputing data, use an if statement to check that you have actually got data before outputting it:

Code: Select all

rs = 'RECORDSET THAT IS OPEN

if rs.EOF = FALSE then

'CODE TO DISPLAY RECORDSET INFORMATION

else

response.write "The query returned no results"

end if