Beg. e-comm. with VB,ASP, SQL & MTS

hopar · October 12th, 2004, 12:26 PM

Hi!
have been tring to submit data to a database.
When i run the page it return with an error of:

Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/JoCofee/checkout.asp

Hope you can help me

Thanks,

coolpeep · January 9th, 2005, 12:02 AM

You definitely need to scour the web and look for database recordset tutorials and follow them closely.

Copy some code and disect it. That is a great way to learn without incurring a lot of expense.

There are also some great books on the market that you find at your local B&N or borders. I think WROX actually publishes one called ASP Databases.

From your question it sounds like your SQL statment is off or you are not using any type of recordset reference in your code to check if any records are to be returned, such as

Code:

IF NOT RS.EOF Then
   Do Until RS.EOF

   strVar1 = RS("field1")

   RS.MoveNext
   Loop
End If

Cheers,
Christian

coolpeep · January 9th, 2005, 12:04 AM

oops...

hey buddy sorry about the code example. that was for a recordset retrieval and i see you are posting information to a database, most likely using the UPDATE query in your SQL statement.

You are most likely trying to update a record by improperly referencing the identity of the record.

Check out the tutorials online or buy a good book.

Thanks in Advance,
CoolPeep

Vadivel · January 10th, 2005, 01:32 AM

1. Use this line to check End of File / Begining of File :: If RSet.EOF And RSet.BOF Then

2. OR Check this link :: http://www.webthang.co.uk/tuts/tuts_...k_errors.asp#5

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com