Order Form

[PCBrandon]

Hello,

I have an order form with ten rows of five fields in a form (so 50 fields). Is there any other way to efficiently enter the data from these fields into a database without having to individually go through each field manually?

Thanks!

 

[Subsume]

Sure is.

I use an ASP library called 'ySQL' which adds or updates a database without very much work at all.

<a href="

http://yeago.net/works/asp-on-rails...works/asp-on-rails-tutorial-part-1-adding</a>

 

[Subsume]

So basically with the above class you'd simply go:


---addOrder.asp---

order = new ySQL

Order.Table("Order_Table")

newID = Order.Add() 'This action goes through your POST and GET variables automatically and matches them up with the table, no need to go thru one by one.