Record Update Form Wizard and repeating area problem.

[marckssg]

Hi,

I've held off posting this for a couple of days as I'm sure its blindingly simple, but I can't find an answer anywhere!

I'm using Dreamweaver MX and SQL server 2000.

I've created a page with the intention of using it to update records that have been entered into my database. I used the Record Update Form Wizard to design my form which works fine for one record. In order to view more than the just the first record I created a repeating area on the form and added a Dataset Navigation Bar.

At this point I can scroll through all the records fine, but as soon as I try and update a record all the existing information is deleted and I'm left with a blank record!

I haven't changed anything on the code side of things and have convinced myself what I'm trying to do should be simple and straight forward and I must be missing something!

Thanks in advance

Cheers

Marc

 

[lebisol]

At this point I can scroll through all the records fine,"

Good,

"but as soon as I try and update a record...."
- how are you updating your records?
I am assuming that you First click on record (view details page) and Then update it on that page.....

...are you looking to Update Multiple records at the same time?
is so take a look at:

http://www.drdev.net/article11.asp

All the best!


:--------------------------------------:

[URL unfurl="true"]http://mostarnet.com[/url]

All around in my home town,
They tryin' to track me down...

 

[marckssg]

Hi,

Thanks for the link I'll have a look and see if I can do multiple records at once.

It was my intention to only display one record per page, I'd limited my SQL to only return records that where live and then was hoping I could scroll through page by page (its quite a small dataset) to edit them.


Cheers

Marc

 

[lebisol]

sure that would work just as well....navigate your records 1 at time (use form elements to display data) while in your repeated region have a form that will update currently viewd record.
All the best!

:--------------------------------------:

[URL unfurl="true"]http://mostarnet.com[/url]

All around in my home town,
They tryin' to track me down...