Forums
This topic is locked
copy db to db
03 Jun 2004 16:54:37 v mr. posted:
hi...im trying to copy a temp database to my main database...users input data into a form-->the form info is sent to the temp and displayed for the user-->if everything is correct the user submits it and the temp db should copy into the main db...i just can't get the temp database to copy over...thanks for your time... Replies
Replied 03 Jun 2004 20:18:31
03 Jun 2004 20:18:31 Dave Thomas replied:
what database are you using?
Regards,
Dave
[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com
Regards,
Dave
[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com
Replied 03 Jun 2004 21:11:53
03 Jun 2004 21:11:53 v mr. replied:
ultradav...i am using access for my db...thanks for the reply
Replied 03 Jun 2004 23:51:45
03 Jun 2004 23:51:45 Dave Thomas replied:
sorry i didnt really read your question correctly the first time.
i thought you meant an import of data.
why are you doing it this way, it doesnt seem very practical in my opinion.
you could have a temp table in your db which when checked could 'drop' the data with no need for a 2nd db.
give me the scenario this is being used in so i can visualise.
Regards,
Dave
[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com
i thought you meant an import of data.
why are you doing it this way, it doesnt seem very practical in my opinion.
you could have a temp table in your db which when checked could 'drop' the data with no need for a 2nd db.
give me the scenario this is being used in so i can visualise.
Regards,
Dave
[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com
Replied 04 Jun 2004 00:25:19
04 Jun 2004 00:25:19 v mr. replied:
i am probably doing it the hard way... this is my scenrio...
1. user fills out form and clicks next
2. information is sent to a temp db
3. a viewing page grabs user info from temp db so he/she can view their input...if they need to change something they can click a back button...they fix the problem and click next...the info is once again stored in temp and viewed...then they can click next to proceed...
4. info is then sent to a main db and emailed to me
i wanted the temp db to be overwritten everytime they go back and change something so one thing would be stored for viewing...if i just used the one db and tried to view user input it shows everyones input in that db...i hope this makes sense...thanks so much for your time..
1. user fills out form and clicks next
2. information is sent to a temp db
3. a viewing page grabs user info from temp db so he/she can view their input...if they need to change something they can click a back button...they fix the problem and click next...the info is once again stored in temp and viewed...then they can click next to proceed...
4. info is then sent to a main db and emailed to me
i wanted the temp db to be overwritten everytime they go back and change something so one thing would be stored for viewing...if i just used the one db and tried to view user input it shows everyones input in that db...i hope this makes sense...thanks so much for your time..
Replied 18 Jun 2004 18:13:37
18 Jun 2004 18:13:37 Simon Martin replied:
Could you just add a flag in your table (active with default value 'n') and when the editor is satisfied with the content of the form they approve it (set the value to 'y').
Then the final info is sent to you (for approval i guess?) so another flag in the table.
Then the final info is sent to you (for approval i guess?) so another flag in the table.