update database from html table

[GoTerps88]

I would like to be able to update the database from an html table. Within the table I'd have a select box for each row. Then elsewhere on the form, I'd have a button to actually update the database.

I'd like to traverse each row in this table and insert a new row into the database based on the selected value of the select box.

To present the table initially, I'd have to wrap the select box in response.write and somehow give each one a unique id.

I'm sure this is possible, but not sure how.

Can you give me a few tips or hints? Thanks...

 

[ChrisHirst]

faq333-4502

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[gbaughma]

You may also want to look into OWC (Office Web Components). I have a web page that I dynamically generate a spreadsheet (right inside of the browser!), let the user make changes, then put that back into a database.



Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com