Here is one I did awhile back
<!--- Open an FTP connection to the Customer Server [ASR] --->
<cfftp
action="LISTDIR"
name="Variables.qFTPDir"
server="#Variables.FTPserver#"
username="#Variables.FTPuser#"
password="#Variables.FTPpassword#"
directory="#Variables.FTPdir#"
stoponerror="Yes"
>
<!--- Run a QofQ for the files [ASR] --->
<cfquery name="variables.MyFile" dbtype="query">
SELECT *
FROM Variables.qFTPDir
WHERE (IsDirectory = 'NO') AND ( Name IN
('isites_ready.txt','HB2_#Variables.TodaysDate#.in.gz') )
</cfquery>
Then check to see if the .RecordCount is GT 0
If Yes, your file exists.
HTH
=]
--
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282422
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
