What is the getmailids Query? You don't have it inside a <cfoutput Query="getmailids" tag do you?
Rick -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 2:15 PM To: CF-Talk Subject: CFLOOP - why are there duplicates? 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:307745 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
