A couple of simple forms questions.

[drewangell]

Forgive me, it's been awhile since I've worked with this stuff...

I'm creating a simple form to use for order entry. I'll need to include
entries for billing information, shipping information, and then I'll have
basically line items which include QTY, model number, description, etc. for the
item being purchased.

Do I need to create seperate forms for each section (ie. Shipping, Billing,
LineItems) or should I create one large form with everything? My page design
seems like it would be easier to create seperate forms, but then how do I
submit all forms to the tables they need with a single submit button?

Any information you can provide would be greatly appreciate.d

Thanks!

[Paul Whitham TMM]

Use a single form, but for ease of entry give the visitor the option to copy
information from one section to another by clicking a checkbox like is shown
here
[url]http://javascript.internet.com/forms/copy-fields.html[/url]

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"drewangell" <webforumsuser@macromedia.com> wrote in message
news:d2udom$f0b$1@forums.macromedia.com...

> Forgive me, it's been awhile since I've worked with this stuff...
>
> I'm creating a simple form to use for order entry. I'll need to include
> entries for billing information, shipping information, and then I'll have
> basically line items which include QTY, model number, description, etc.

for the

> item being purchased.
>
> Do I need to create seperate forms for each section (ie. Shipping,

Billing,

> LineItems) or should I create one large form with everything? My page

design

> seems like it would be easier to create seperate forms, but then how do I
> submit all forms to the tables they need with a single submit button?
>
> Any information you can provide would be greatly appreciate.d
>
> Thanks!
>

[drewangell]

Thanks for that link...I needed that.

Any info on how this insert is going to work though? With the shipping and
billing held in 2 different tables how do I make that work? The billing
information is held in the customers table while the shipping information is
held in the Orders table via CustomerID field. So, If I tell the insert to
apply to the Orders table how is going to know to place the billing information
and all that in the customers table? Or, if I have it insert into the
Customers table first how would it then create an order for the person?

[drewangell]

Ok, well I'm getting closer.

I found a link to a nice short guide on how to insert into more than one
table: [url]http://www.drdev.net/article01.htm[/url].

I think I've got it all setup correctly, but I'm not sure what to put for the
action of the form. The tutorial there doesn't really get into that part.

When I use the DW insert record behavior it puts a variable name in for the
action and then has:

MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If

above everything. Do i need to do something similiar to this or how do I make
this work???

Any info is awesome! thanks!

[Paul Whitham TMM]

You action code for the form will simply be to call the same page, assuming
that you have put all the code on the same page (which is what DW does by
default)

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"drewangell" <webforumsuser@macromedia.com> wrote in message
news:d310ea$f6v$1@forums.macromedia.com...

> Ok, well I'm getting closer.
>
> I found a link to a nice short guide on how to insert into more than one
> table: [url]http://www.drdev.net/article01.htm[/url].
>
> I think I've got it all setup correctly, but I'm not sure what to put for

the

> action of the form. The tutorial there doesn't really get into that part.
>
> When I use the DW insert record behavior it puts a variable name in for

the

> action and then has:
>
> MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
> If (Request.QueryString <> "") Then
> MM_editAction = MM_editAction & "?" &

Server.HTMLEncode(Request.QueryString)

> End If
>
> above everything. Do i need to do something similiar to this or how do I

make

> this work???
>
> Any info is awesome! thanks!
>

[drewangell]

Yes, I did get it working by calling the same page. I appreciate your help.

Is there a way I can make it then go on to another page, though? Right now it
just submits and clears out the form and remains on that same page. I would
like it to go to a "completed successfully" page of some sort.

How can I make this happen?

[Paul Whitham TMM]

Just place a redirect on the page after the insert code has executed like
this

Response.Redirect("page.asp")

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"drewangell" <webforumsuser@macromedia.com> wrote in message
news:d31l8i$emu$1@forums.macromedia.com...

> Yes, I did get it working by calling the same page. I appreciate your

help.

>
> Is there a way I can make it then go on to another page, though? Right

now it

> just submits and clears out the form and remains on that same page. I

would

> like it to go to a "completed successfully" page of some sort.
>
> How can I make this happen?
>

[drewangell]

Where should I put that? I put Response.Redirect(woodOrderForm.asp) right
after the comm inserts and I'm getting the error:

Microsoft VBScript runtime (0x800A01A8)
Object required: 'woodOrderEntryComplete'
/KennysTile/woodOrderForm/index2.asp, line 80

[Paul Whitham TMM]

Find the last line of the insert statement which should be an "End IF" and
place it in front of that

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Paul Whitham TMM" <paul@valleybiz.net> wrote in message
news:d31lp2$fd3$1@forums.macromedia.com...

> Just place a redirect on the page after the insert code has executed like
> this
>
> Response.Redirect("page.asp")
>
> --
> Regards
>
> Paul Whitham
> Macromedia Certified Professional for Dreamweaver MX2004
> Valleybiz Internet Design
> [url]www.valleybiz.net[/url]
>
> Team Macromedia Volunteer for Ultradev/Dreamweaver MX
> [url]www.macromedia.com/support/forums/team_macromedia[/url]
>
> "drewangell" <webforumsuser@macromedia.com> wrote in message
> news:d31l8i$emu$1@forums.macromedia.com...

> > Yes, I did get it working by calling the same page. I appreciate your

> help.

> >
> > Is there a way I can make it then go on to another page, though? Right

> now it

> > just submits and clears out the form and remains on that same page. I

> would

> > like it to go to a "completed successfully" page of some sort.
> >
> > How can I make this happen?
> >

>
>