RE: Need help searching for files in a directory
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
Re: Need help searching for files in a directory
QofQ is case sensitive. So if you search for name LIKE '%Alanis%', it is NOT the same as searching for '%alanis%', or '%aLaNiS%'. The force it to be case-INsensitive, use a couple of functions: SELECT * FROM qryResult WHERE lower(name) LIKE '%#lCase(form.findThis)#%' Hope that helps. On 2/10/07, Bob Imperial [EMAIL PROTECTED] wrote: 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 ~| 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:269441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need help searching for files in a directory
Thanks Matt...this covers the two possibilities of upper and lower case .. Select * from qryResult Where lower(name) Like '%#form.findThis#%' OR upper(name) Like '%#form.findThis#%' I guess maybe I should address the other possibilities by eliminating the uploading of mixed case names on the front end via javascript ;-) Thanks again!! Bob -Original Message- From: Matt Quackenbush [mailto:[EMAIL PROTECTED] Sent: Saturday, February 10, 2007 10:28 PM To: CF-Talk Subject: Re: Need help searching for files in a directory QofQ is case sensitive. So if you search for name LIKE '%Alanis%', it is NOT the same as searching for '%alanis%', or '%aLaNiS%'. The force it to be case-INsensitive, use a couple of functions: SELECT * FROM qryResult WHERE lower(name) LIKE '%#lCase(form.findThis)#%' Hope that helps. On 2/10/07, Bob Imperial [EMAIL PROTECTED] wrote: 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 ~| 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:269443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help searching for files in a directory
No need for that. If you look at my example, you'll see that I used lCase() ColdFusion function to make sure that the form value was in lower case as well. So it covers it all. On 2/10/07, Bob Imperial [EMAIL PROTECTED] wrote: Thanks Matt...this covers the two possibilities of upper and lower case .. Select * from qryResult Where lower(name) Like '%#form.findThis#%' OR upper(name) Like '%#form.findThis#%' I guess maybe I should address the other possibilities by eliminating the uploading of mixed case names on the front end via javascript ;-) Thanks again!! 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:269444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need help searching for files in a directory
Ahhh so am I understanding this correctly, it converts it to lower case before it actually sends the request to the db? -Original Message- From: Matt Quackenbush [mailto:[EMAIL PROTECTED] Sent: Sunday, February 11, 2007 12:49 AM To: CF-Talk Subject: Re: Need help searching for files in a directory No need for that. If you look at my example, you'll see that I used lCase() ColdFusion function to make sure that the form value was in lower case as well. So it covers it all. On 2/10/07, Bob Imperial [EMAIL PROTECTED] wrote: Thanks Matt...this covers the two possibilities of upper and lower case .. Select * from qryResult Where lower(name) Like '%#form.findThis#%' OR upper(name) Like '%#form.findThis#%' I guess maybe I should address the other possibilities by eliminating the uploading of mixed case names on the front end via javascript ;-) Thanks again!! 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:269445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need help searching for files in a directory
Well, it's not actually sending to a database in this particular query; it's querying a previous query. But yes, the CF function will process before making the query request, thereby converting the form var to lower case. Then by using the SQL lower() function on the column that you're querying, it also will be in lower case. On 2/11/07, Bob Imperial [EMAIL PROTECTED] wrote: Ahhh so am I understanding this correctly, it converts it to lower case before it actually sends the request to the db? ~| 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:269451 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Need help searching for files in a directory
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:269278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help searching for files in a directory
What are your search criteria? Filename, ID3? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Bob Imperial To: CF-Talk Sent: Fri Feb 09 08:58:00 2007 Subject: Need help searching for files in a directory 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:269279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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:269281 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need help searching for files in a directory
Will be filename...or something like it. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 4:16 AM To: CF-Talk Subject: Re: Need help searching for files in a directory What are your search criteria? Filename, ID3? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Bob Imperial To: CF-Talk Sent: Fri Feb 09 08:58:00 2007 Subject: Need help searching for files in a directory 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:269287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need help searching for files in a directory
Thanks Gert!! I knew it would be something relatively simple, but at 4AM things just don't always fall into place ;-) Now that I've had some sleep, it's off to come up with more things to ponder. 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:269288 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
