Thanks again for the help on this Gert! I've setup my output but I ran into
something I'm not sure of the syntax on how to fix this. When passing the
search criteria via my form variable, it only returns exact matches in
case......here's what I have setup:
<cfdirectory action="LIST" directory="D:\wwwsites\mysite\#ThisDir#\"
name="qryResult"
filter="#ThisFilter#" recurse="Yes">
<cfquery name="getFile" dbtype="query">
Select * from qryResult Where name Like '%#form.findThis#%'
</cfquery>
I've tried to use ListFindNoCase but it doesn't seem to work, or at least
not in the ways I've tried. Is there a way to handle what I'm after with it
or is there some other approach I should be taking? Thanks again for all the
help!
Bob
-----Original Message-----
From: Gert Franz [mailto:[EMAIL PROTECTED]
Sent: Friday, February 09, 2007 4:45 AM
To: CF-Talk
Subject: Re: Need help searching for files in a directory
Well since you qould try to use verity and verity does not index mp3 files
for their content, I assume you are just looking for a filename.
So what you can do is (assuming you have cfmx7):
<cfdirectory action="LIST" directory="D:\multimedia" name="qryResult"
filter="*.mp3" recurse="Yes">
<cfquery name="getFile" dbtype="query">
Select * from qryResult Where name Like '%Alanis%'
</cfquery>
<cfdump var="#getFile#">
Greetings / Grüsse
Gert Franz
Customer Care
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch
Join our Mailing List / Treten Sie unserer Mailingliste bei:
deutsch: http://de.groups.yahoo.com/group/railo/
english: http://groups.yahoo.com/group/railo_talk/
Bob Imperial schrieb:
> I'm trying to figure out how to go about searching through a directory
> of
> mp3 files I have in a shared hosting environment so no verity. The
> search criteria would be passed via a form variable, so, I'm wondering
> if it's possible to use cfdirectory list and maybe dump the results
> into an array, then do loop through the array using listfindnocase on
> it to find the specific file?? Any help or direction would be greatly
> appreciated, I've goggled it to death only to run into the verity
> avenue, which I can do locally, but alas, not in my shared hosting
scenario.
>
> Thanks!! Bob
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269432
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
