same field, multiple entries

[asta]

I would like to add more than one record, per form, to a field in a Access datbase. Can it be done, and if so, what am I leaving out.


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>

Thanks

 

[Klotzki]

I don't think so. I was trying to do the same thing but I think inserting multiple records with no reiteration / loop is possible with MS Jet SQL (Ms Access's database engine)

What I did was just to loop through the records I want and do the CFQUERY w/ INSERT SQL command for each record.

Klotzki