Re: File exists check failed

[Dan Munez]

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

Re: File exists check failed

[Andrew Scott]

I am assuming that you have opened explorer and tried this

\\10.1.0.192\foldername\126894.pdf'

And does it work?


On 6/12/07, Selvakumar Selvaraj [EMAIL PROTECTED]
wrote:

 Hi All,

 I have a problen in my SQL script,

 declare @Path varchar(128) ,
@FileName varchar(128)
select  @Path = '\\10.1.0.192\' ,
@FileName = 'foldername\126894.pdf'

 declare @i int
 declare @File varchar(1000)

select @File = @Path + @FileName
print @File
exec master..xp_fileexist @File, @i out
if @i = 1
print 'exists'
else
print 'not exists'

 but it says not exists.

 The file exists in different server. I have given full rights for this
 folder. But still getting the same. Please help to resolve this.

 Thanks in advance,
 Selva

 

~|
Create Web Applications With ColdFusion MX7  Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2856
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6

Re: File exists check failed

[Selvakumar Selvaraj]

I am assuming that you have opened explorer and tried this

\\10.1.0.192\foldername\126894.pdf'

And does it work?


On 6/12/07, Selvakumar Selvaraj [EMAIL PROTECTED]
wrote:

Hi Andrew,

Thanks for the response. You are correct. I am able to ping that IP and i am 
able to open that file thru explorer. Am i missing some thing related to 
privillages?

~|
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:2857
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6