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
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280290
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
