|
| |
|
|
charlie df
Posts: 79
From: las vegas nv USA
Status: offline
 |
wondering if this can be done - 8/15/2001 14:48:00
I would like to use one form to update 2 tables in a database, one alwasy gets updated, and the other gets update if certain condtionons are met.Table 1: updated no matter what, adding a new record to the table.
Table 2: Would be updated by using information ( a comparison of 2 numbers) form Table 2 to determine if a condition is met. If the condition is met then one of the 2 numbers would then be updated. I have just started to learn VBScript, and think I can put together the If..Then..Else script, but not sure about submitting one form to do the adding and updating of records. Thanks for any help anyone can offer me.
|
|
|
|
Spooky
Posts: 26597
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: wondering if this can be done - 8/15/2001 16:36:00
Assuming you have a working database update, you would do something like :<%
Open.Database connection ' Execute(Do database #1 code) If Comparison a <> B then ' Execute(Do update # 2 code) End if
Close.Database connection
------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
VP-ASP Shopping cart
| |
|
|
|
charlie df
Posts: 79
From: las vegas nv USA
Status: offline
|
RE: wondering if this can be done - 8/15/2001 16:48:00
Thanks spooky, I'm going to give it a try. Like I said, i am just starting out in VBScript, so I will try to get my if then else statements right, if I have any problem I'll be back. Just glad to know that it's possible and I am not wasting my time.
| |
|
 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 
