>>I check the file name and see if it already exists in the database. If it does, then I return the error. If it doesn't exist, then go and perform the <cffile> action.
This is the way you see it, but not the best and easiest way to do it. This is the way I do it: - upload the file and rename it on the server with a unique local name, ie: CreateUUID() - store in the database both the local name and the original name. This way, you can have several files with the same original name. When a user retrieves a file, you can read it using the local name, and send it under the original name, users will never see the local name. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4