Not a dumb question ... could have been the issue. But it not in this instance.
>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: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:307746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

