dumb question but... gotta ask. are you inserting the 100 records into the table that originally had 100 records (thus resulting in 200)?
how do you know that the "getmailids" query had 100 records? can you verify? are you getting 200 inserts or are you just ending up with 200 records in the table (if the latter, see the original question). can you set a counter to zero before the cfloop, increment it by 1 inside the loop, then output outside the loop to see exactly how many times the loop iterates? output #getmailids.recordcount# to see if the value you end up with is the same as the resulting counter variable value. it *should* be... so the question becomes is that number what you expected? On Thu, Jun 19, 2008 at 12:15 PM, <[EMAIL PROTECTED]> wrote: > 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:307740 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
