Maureen wrote:
> Instead of doing a loop over the array of structures and doing an
> insert each for each structure, you can do
> <cfquery name="blah" datasource="dsn">
> insert (field1, field2, field3)
> values (
> <cfloop index="x" from="1" to="lenarray">
> arrayname[x,value1], arrayname[x,value2], arrayname[x,value3]
> </cfloop>
> )
> </cfquery>
Hey Maureen,
Are you sure this functionality exists within SQL? It would seem like
you'd either end up with
INSERT INTO Tracks (ProductID) VALUES ('2343234','223432432','123213')
or
INSERT INTO Tracks (ProductID) VALUES ('2343234'), ('223432432'), ('123213')
depending on where you put the parenthesis and neither version works.
Thanks,
Mike
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319340
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
