Error on page

[BravoTwoZero]

Hi All, I am having problem with bof and eof. can any body please help? Error Type: ADODB.Field (0x80020009) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. :rolleyes: Many Thanks.. Bravo Two Zero A pen is mighter then a sword.

[Steve McLenithan]

that means that the sql query executed returned 0 records. ******************** * $TeVe McLeNiThAn ********************

[Paul Ingles]

As Steve pointed out, you're trying to access a record's data but you've either gone past the end of the records, or none were returned. If you use Do While Not Recordset.EOF then you can loop through and anything done inside the loop will be on valid records (providing you use Recordset.MoveNext inside the loop). Alternatively, use If Not Recordset.EOF if you're only expecting to have a single record returned. -- Paul "If you can keep your head when all around you have lost theirs, then you probably haven't understood the seriousness of the situation." - David Brent, from "The Office" MS Messenger: paul@oobaloo.co.uk Sonork: 100.22446