|
| |
|
|
ACEDISH
Posts: 176
Joined: 9/30/2002
From: Manassas, Virginia
Status: offline
 |
Submitting to multiple databases - 6/24/2003 18:11:21
I searched the forum and couldn' t find anything on this.
Basically I have a database that has 1 table and 120 columns. I am passing data between 5 pages and the submitting on the last so I would like to break the data up into 3 tables or 3 databases from 1 submission. I am using access
Also is 1 way better then another submitting to multiple tables or multiple databases?
_____________________________
" Anyone who can only think of one way to spell a word obviously lacks imagination"
|
|
|
|
Mojo
Posts: 2443
From: Chicago
Status: offline
|
RE: Submitting to multiple databases - 6/25/2003 0:34:01
Using multiple tables would easily be prefered over multiple databases.
To connect to multiple tables is a snap > Just create a new recordset.
... make the datbase connection
oConn.open
sSQL = " update table1 set column1 = ' foo' "
set oRS = oConn.execute(sSQL)
sSQL = " update table2 set column1 = ' hello' "
set oRS = oConn.execute(sSQL)
repeat as needed...
_____________________________
Split Testing
Order Fulfillment
Emergency Kits
| |
|
|
|
ACEDISH
Posts: 176
Joined: 9/30/2002
From: Manassas, Virginia
Status: offline
|
RE: Submitting to multiple databases - 6/25/2003 8:25:06
Thanks, I use frontpage which i know can' t do this. Would I post all data to a page and then make the connection and submit? or is there a way to put the page on a diet and insert another database connection and query?
< Message edited by acedish -- 6/25/2003 8:30:46 AM >
_____________________________
" Anyone who can only think of one way to spell a word obviously lacks imagination"
| |
|
|
|
ACEDISH
Posts: 176
Joined: 9/30/2002
From: Manassas, Virginia
Status: offline
|
RE: Submitting to multiple databases - 6/25/2003 13:28:48
Still can' t find anything, what about updating a database after posting to a different database?
When posting to a database can you have the confirmation page be an update page for a differnt database? I need to update 1 field on the update page. I know how to get the Id on the confirmation page but I cannot seem to get it to update.
_____________________________
" Anyone who can only think of one way to spell a word obviously lacks imagination"
| |
|
 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 
