Sql Server

[sjb34]

Hi all.
The error below appears when a form is completed and sent to the db, and then
should return the user to the home page.
When I look in the db, the details are inserted into the table but it won't
redirect, hence the message. File paths are correct.
Also, the other problem I am having is inserting the date into the db from a
hidden field in the form. It keeps entering a NULL value in the db. Any ideas?

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

[Julian Roberts]

The error means that your recordset is empty. Check that you've bound the
hidden box to the correct database field.

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Merlyn MM]

I'm using sql server 8 and I have orders table and everytime it picks an order
on a scanner its pulling the correct order but out of 900 orders 3orders were
wrong. Is it something wrong with my coldfusion or the sql server ? Please help
me someone. Is it a sql server indexing problem or my programming?

[mxstu]

Can you be more specific? What do you mean "3 orders were wrong"?