Forums
This topic is locked
Updating whole table???
Posted 04 Mar 2002 10:08:04
1
has voted
04 Mar 2002 10:08:04 hakawati hakawati posted:
<font face='Verdana'></font id='Verdana'>Hello, I want to display the whole table of a database on a webpage and then allow the user to change(update) the records of the table.
I am doing this with following "functions" integrated in ultradev: First I am displaying the data of the recordset -> then i choose "Repeat region" from the Server behavior menu to display the whole table-> after the I am using the "update record" function from the same menu(applying on the same recordset). All is fine until now, but when i try to change something in the table and press the update button, just the first row is updated(also with values of the following 5 rows, curious?) What I am doing wrong?
Replies
Replied 05 Mar 2002 06:38:53
05 Mar 2002 06:38:53 Steven Tam replied:
that's becuase the update command only update one record at a time and since you didn't specify which record to update, it default to the first record in the recordset. normally, you want to take the user to a form with only one record to edit.
Replied 06 Mar 2002 17:10:05
06 Mar 2002 17:10:05 Andrew Watson replied:
this can be done, there was a post recently titled updating multiple records, find it and all will be clear.....
Replied 07 Mar 2002 01:20:41
07 Mar 2002 01:20:41 hakawati hakawati replied:
<font face='Verdana'></font id='Verdana'>
Thanks alot for all hints. I found the solution under following link:
www.udzone.com/showDetail.asp?TypeId=2&NewsId=1714&LinkFile=step7.html
Thanks alot for all hints. I found the solution under following link:
www.udzone.com/showDetail.asp?TypeId=2&NewsId=1714&LinkFile=step7.html