I'm trying to us the output from a query to loop through and insert statement.
My original query has 100k for a recordcount. When I run it through the insert
statement below, I end up with 200k inserts. Just need another set of eyes.
Thanks.
<CFLOOP query="getmailids">
<CFQUERY name="INS_TASK_DONE_DATE" datasource="stonyfieldcustom">
INSERT INTO sub
(
mailprofileID,
newslettertypeID,
datesubscribed
)
vALUES
(
#getmailids.mailprofileID#,
681065,
#CreateODBCDateTime(now())#
)
</CFQUERY>
</CFLOOP>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307739
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
