Not sure if this is a typo BUT: There is a space between '06Jun2007_ ILS' in your query statement but not in your Logs Record set
SQL SELECT Name FROM Logs WHERE Name = 'ChargedOut_06Jun2007_ ILS_105634322.txt' -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 06, 2007 3:35 PM To: CF-Talk Subject: Any see what is wrong with this query? Logs Record Set - query - Top 4 of 4 Rows ATTRIBUTES DATELASTMODIFIED DIRECTORY MODE NAME SIZE TYPE 1 [empty string] 06/06/2007 10:59:17 AM G:\Tracker\wwwRoot\Data [empty string] ChargedOut_06Jun2007_ILS_105634322.txt 828 File 2 [empty string] 06/06/2007 10:57:00 AM G:\Tracker\wwwRoot\Data [empty string] Error_06Jun2007_ ILS_105634322.txt 88 File 3 [empty string] 06/06/2007 10:58:46 AM G:\Tracker\wwwRoot\Data [empty string] Final_06Jun2007_ ILS_105634322.txt 27841 File 4 [empty string] 06/06/2007 10:56:07 AM G:\Tracker\wwwRoot\Data [empty string] Upload_06Jun2007_ ILS_105634322.txt 94768 File ChargeOut Stats - struct CACHED false COLUMNLIST NAME EXECUTIONTIME 0 RECORDCOUNT 0 SQL SELECT Name FROM Logs WHERE Name = 'ChargedOut_06Jun2007_ ILS_105634322.txt' chargeOut Record Set - query - Top 0 of 0 Rows NAME CODE ---- <cfdirectory directory="#ExpandPath('data')#" action="list" name="Logs" sort="Name"> ..... <cfquery dbtype="query" name="ChargedOut" result="stats"> SELECT Name FROM Logs WHERE Name = 'ChargedOut#Set#.txt' </cfquery> I can not see why SELECT Name FROM Logs WHERE Name = 'ChargedOut_06Jun2007_ ILS_105634322.txt' is not returning the corresponding record from the logs record set. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280294 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
