updating a database

[Aaronito]

I have an access database used to keep addresses, phone #s, email, etc.... I have search pages and an insert page for a new entry....

I am trying add a page to update an existing entry, created in UltraDev but get this error when running:

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

I had something working before but it kept updating every entry with the same last name...

I have a primary key in the db (autonumbered ID)

 

[Cheech]

I normally have a selection page where all records are shown then highlight one of the fields and select a server behaviour of Go to detail page. On this page I have the recordset filtered to only display the record Id as passed. The populate a form with your database entries and off you go. The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)

 

[Aaronito]

Cheech,

I think that is what I am/was trying to do. Would you happen to have something by way of an example?

 

[Cheech]

master.asp

recordset query for all records

put in a table with a repeat region

table cells

field1 field2 etc..

bind field 1 to your unique id field

highlight field1 go to server behaviours>go to detail page.

detail.asp

recordset query on database filter id = passed url id

formon page

text field or whatever is required for each field

bind the record field to the textfield.

hope that helps a bit, it is a bit vague but without details of your database structure and so forth I cant be much more specific.

To learn more the onboard help files may be of use. The tutorial will teach you how to do the above as well. The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)