is name a char type vs a varchar, if so, you'll have to pad with
spaces on the right.
On 6/6/07, Ian Skinner <[EMAIL PROTECTED]> wrote:
> 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:280293
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
