The user account that the CF service runs under is important. Instead of using the default account, you should use a network account if you want network access. Although this is described in the knowledge base, you shouldn't regard this switch as trivial, especially if you are trying to make the switch on a production server. Someone with server admin experience should make the user account switch. Another possibility is to come up with something in the middle between CF and the file and assign that middle piece the required network permissions.
Also, UNC is preferred over mapped drives. -Mike Chabot On Fri, Feb 27, 2009 at 2:44 PM, Tara Alexander <[email protected]> wrote: > > Hi - Every month I have a page that shows reports for countless properties. > I use the FileExists to check if the file is there - if it is then the month > shows as an active link - if not then the month displays in regular font. > This works great for all the reports so far as they have all been stored on > the same server (the ColdFusion server). > > Now I have another department wanting me to display their reports and they do > not have access to the ColdFusion server. The FileExists cannot "see" the > files. If I hard code it to display a link the file will open - so I know > the path is correct. I've tried using the ip address instead of the mapped > drive thinking that would be faster - but FileExists does not see it then > either. Any suggestions? Many thanks!!!! Here's the code that is looking at > a different server (sorry - it may not be that great - I'm a very junior CF > programmer) pdfmonths cfset as is JAN thru DEC. > > <tr> > <td align="right">Sales Summary: </td> > <td> </td> > <CFLOOP LIST="#pdfmonths#" INDEX="i"> > <td><CFIF FileExists("p:\Sales Month End #year#\#year# Sales > Summary\#i# #year#\#trim(q_hotels.SalesSummaryReport)# #i# #year#.doc") is > 'YES'> > <a href="p:\Sales Month End #year#\#year# > Sales Summary\#i# #year#\#trim(q_hotels.SalesSummaryReport)# #i# #year#.doc" > target="_blank">#i#</a> > <CFELSE>#i#</CFIF></td> > <td> </td> > </CFLOOP> > </tr> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
