|
| |
|
|
ausmoran
Posts: 1
Joined: 6/20/2007
Status: offline
 |
Entering Data Into Three SQL Tables - 6/20/2007 8:56:49
I am completely new to DW (MX 2004) and am in need of someone's assistance. I have created an asp page in which I have a simple form that allows users to enter demographic data that will be stored in the VOLUNTEERS table. I also need to provide a mechanism for those same people to enter data in the COMMITTEE_VOLUNTEERS table. This Committee_Volunteers table contains primarily checkboxes (BIT) for various committees that volunteers may join, along with several other VARCHAR type fields. Some of the data for the COMMITTEE_VOLUNTEERS table is linked from a COMMITTEES table (this table stores a list of committees, and term).
Do I need two separate asp pages in order to provide a simple mechanism for users to enter and submit data to my SQL database? Or can I create a Stored Procedure in which I join all of the tables and then use that as the underlying data source for all of the required fields?
As I said, I am very new to this so am not really sure which way to go.
Thanks ever so much (in advance),
-Austin
|
|
|
|
rdouglass
Posts: 9224
From: Biddeford, ME USA
Status: offline
|
RE: Entering Data Into Three SQL Tables - 6/20/2007 11:43:32
Hi and Welcome to OutFront.
I'm not sure how DW works, but with just ASP you can put several forms on the same page or it could be all on 1 big form and you'd let a form handler take care of which data goes to which table.
But if it is a wizard kinda' thing you're relying on, I wouldn't know since I don't know DW. However, adding data to multiple tables is a very common thing and is done all the time (as you probably already know.)
Hope that helps.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
mar0364
Posts: 3091
Joined: 4/5/2002
From: Florida, US
Status: offline
|
RE: Entering Data Into Three SQL Tables - 6/20/2007 12:19:54
If you want to stay within Dreamweaver Server Behaviors you will need a separate page for each update action. If you want to write the ASP by hand you can most certainly do it.
If you intend on maintaining the site I would write this by hand just to get a feel for what DW is generating for you. This will allow you to do so much more.
If your going to try it by hand I would ask a moderator to move the thread to the ASP and Databases forum.
Whatever you decide I wish you the best!
Regards!
Rich
_____________________________
Easy Web
“Stay committed to your decisions, but stay flexible in your approach.”
| |
|
 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 
