multiple entries

[RanchX]

How can I add multiple records to one table field? I'm using Cold Fusion for the front end, and it won't allow me to add more than one record per form.

FYI, it uses standard SQL query statements.

This is what I've got now:

<CFQUERY NAME=&quot;multiple_entry&quot; DATASOURCE=&quot;Test_Stuff&quot;>
INSERT INTO multiple_entries_same_field (item_one, item_one)
VALUES('#item_one#', '#item_one#')
</CFQUERY>

I'm sure I'm missing a clause.
Thanks

 

[foxdev]

I'm not experienced with Cold Fusion (maybe next week), but the INSERT INTO table VALUES (MyValues) statement is designed to create one record.

It may be that your problem is specifically with Cold Fusion, in that it is not looping through and adding multiple records based on some form values. In that case, it might be a better Q for the Cold Fusion forum.

Robert Bradley

http://www.foxdev.com/