|
| |
|
|
Toolman
Posts: 203
Joined: 3/14/2002
From: United Kingdom
Status: offline
 |
Updating data in Access - 5/3/2002 4:00:05
Can anyone help me with the following?
I have an .asp page that looks up data from an Access database and then a seperate form for submitting data back to the database.
I need to copy the asp data to the submitting form from the .asp form when I open it.
Is this possible using the features in frontpage or will i need to do some HTML code work?
Thanks
|
|
|
|
JeroenDortmans
Posts: 66
From: Eindhoven Netherlands
Status: offline
|
RE: Updating data in Access - 5/3/2002 10:22:59
Hi,
When you want to update the data, you just retrieved from a database you have to send the data from your lookup page to an update page. So to edit the data your lookup page must have text fields. Then you post the data from this page by clicking the submit button to an update page. On this update page you insert a custom query. The SQL syntax you insert here must look something like this:
"UPDATE table_name SET column_name='::column_name::', column_name='::column_name::', column_name='::column_name::' WHERE unique_ID_column_name=::unique_ID_column_name::"
This update page also must have the extension .asp. Hope this helps.
Jeroen Dortmans
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
