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>&nbsp;</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>&nbsp;&nbsp;</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:319926
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to