Can you be a little more explicit about how you do that, Claude? I've never used CreateUUID before.
Do you create a temporary UUID for each file to use for comparison with potential insert values? > -----Original Message----- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Friday, May 16, 2008 11:10 AM > To: CF-Talk > Subject: Re: What's wrong with this query? > > >>I don't remember ever running a query like this one, so I'm > not sure it's even a valid approach. > > My approach is to rename every file using CreateUUID > <Functions53.html#1102827>() function. > to make sure there is no duplicate problem. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305440 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

