Question
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.
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.