Forums

This topic is locked

Multiple reocrds insert

Posted 25 Nov 2003 23:26:32
1
has voted
25 Nov 2003 23:26:32 Joe Katz posted:
I have a detail page that lists out multple records. I need to send each reocrds to a database. I am able to update single records with the DW insert behavoir. How can I acomplish this with multiple reocrds.

Thanks
Joe

Replies

Replied 27 Nov 2003 09:34:24
27 Nov 2003 09:34:24 Nozomi Kugita replied:
Are you inserting new records or updating existing records?

- Noz
Replied 01 Dec 2003 17:04:52
01 Dec 2003 17:04:52 Joe Katz replied:
I am inserting new records.
Replied 02 Dec 2003 04:18:25
02 Dec 2003 04:18:25 Nozomi Kugita replied:
I don't believe you can perform what you are expecting with Dreamweaver's prepared behaviors. I don't know which server technology you are using, so here's an idea.

You can insert multiple records by looping a code block that inserts a record to a database table. If you are displaying multiple records from a different database table, you may beable to know how many records exist in the recordset, so you just need to loop while that recordcount, to insert each records.You may also use hiddne fields alternately and send each form values to the database.

Reply to this topic