|
| |
|
|
Nev
Posts: 3
Joined: 1/30/2002
From: Westland MI USA
Status: offline
 |
Updating a Database with Form Results - 1/30/2002 17:10:50
Hi people.
I'm having trouble updating a database with form results. I have followed the correct steps and have gone through the additional steps in Spooky's Database FAQ entitled "Save to Database Form Gives Confirmation but Does Not Add Data to Database" but the database is still not being updated. Do you have any suggestions to get it to work. Thanks for your help.
Nev.
|
|
|
|
J-man
Posts: 936
From: Canada
Status: offline
|
RE: Updating a Database with Form Results - 1/30/2002 17:49:08
what type of connection are you using, do you get any errors... maybe you should post your code.. if it isn't too long..
| |
|
|
|
eYeLinkZ
Posts: 94
Joined: 1/13/2002
From: Mississauga Ontario Canada
Status: offline
|
RE: Updating a Database with Form Results - 1/31/2002 5:57:31
is that you want to update your database with a new record or you want to update a present record?
to add a new record you can use save to database form and it should work.
but if u want to update a record in the database, then u should use update command (sql).
<%=Mazhar()%>
| |
|
|
|
Nev
Posts: 3
Joined: 1/30/2002
From: Westland MI USA
Status: offline
|
RE: Updating a Database with Form Results - 2/4/2002 9:28:04
I just want to add an entirely new record. I used the Save to Database form and as you said it should work - but it doesn't, that's the problem. There shouldn't be any need for code.
The only other reason I can think of why the databse is not being updated with the form results may be that I don't have the correct database drivers installed on the server. It's an Access 2000 database, Web pages created in Frontpage 2000, and server running IIS with Frontpage 2002 Server Extensions. Anyone know what database drivers I should have installed on the server?
quote:
is that you want to update your database with a new record or you want to update a present record?
to add a new record you can use save to database form and it should work.
but if u want to update a record in the database, then u should use update command (sql).
<%=Mazhar()%>
Nev.
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Updating a Database with Form Results - 2/4/2002 19:09:52
How do you test it is not updated, and is an error produced at all?
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
Nev
Posts: 3
Joined: 1/30/2002
From: Westland MI USA
Status: offline
|
RE: Updating a Database with Form Results - 2/6/2002 16:16:19
To test it, I enter test data into the form on the published web site and submit. I get the Results Confirmation page - no error.
I then open the database on the web server which is on our own local network and take a look at the table which should have been updated with a new record but there is no data in the table.
Can you help Spooky?
Nev.
| |
|
 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 
