Whoa I never knew u could use SQl to check if a file exists. What other directory functions can it do?
> > declare @Path varchar(128) , > @FileName varchar(128) > select @Path = '\\10.1.0.192\' , > @FileName = 'foldername\126894.pdf' > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2859 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6