RE: Coldfusion Search
Anyone have any ideas on this? -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Monday, November 01, 2010 4:46 PM To: cf-talk Subject: Coldfusion Search Hi All, I've created a file index of all of my ColdFusion files so I can quickly search the files and find what I'm looking for. So far, it's working great except it doesn't seem to be searching inside any coldfusion tags. For example pIf I searched for this text, It would return a result/p cfset variables.foo = however, If I search for this text it wouldn't return any results. / Does anyone know if there's a way to search inside of a coldfusion tag like that? This is my index. cfindex collection = fileIndex action=refresh type=path key=d:\my-websites-location\ urlpath=http://mywebsite/; extensions=.cfm, .cfml, .cfc recurse=Yes This is my search. cfsearch name = testSearch collection = fileIndex type=internet criteria = variables.foo / Any ideas? Thanks, Paul : ) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Search
If I had to guess I'd say Verity is ignoring the code as it looks like HTML. On Mon, Nov 1, 2010 at 3:45 PM, Paul Alkema paulalkemadesi...@gmail.com wrote: Hi All, I've created a file index of all of my ColdFusion files so I can quickly search the files and find what I'm looking for. So far, it's working great except it doesn't seem to be searching inside any coldfusion tags. For example. pIf I searched for this text, It would return a result/p cfset variables.foo = however, If I search for this text it wouldn't return any results. / Does anyone know if there's a way to search inside of a coldfusion tag like that? This is my index.. cfindex collection = fileIndex action=refresh type=path key=d:\my-websites-location\ urlpath=http://mywebsite/; extensions=.cfm, .cfml, .cfc recurse=Yes This is my search. cfsearch name = testSearch collection = fileIndex type=internet criteria = variables.foo / Any ideas? Thanks, Paul : ) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion Search
Hi All, I've created a file index of all of my ColdFusion files so I can quickly search the files and find what I'm looking for. So far, it's working great except it doesn't seem to be searching inside any coldfusion tags. For example. pIf I searched for this text, It would return a result/p cfset variables.foo = however, If I search for this text it wouldn't return any results. / Does anyone know if there's a way to search inside of a coldfusion tag like that? This is my index.. cfindex collection = fileIndex action=refresh type=path key=d:\my-websites-location\ urlpath=http://mywebsite/; extensions=.cfm, .cfml, .cfc recurse=Yes This is my search. cfsearch name = testSearch collection = fileIndex type=internet criteria = variables.foo / Any ideas? Thanks, Paul : ) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
No ColdFusion Search Services
I'm attempting to make my first application using the CF9 Solr search feature. So I logged into the Administrator to make a collection of some web directories, and I get this message: Unable to retrieve collections from any of the Search Services. Please verify that atleast one of ColdFusion Search Services are installed and running. I'm pretty sure we installed Solr when we did the installation, how would one go about checking that it is installed, running and healthy? This would be on a Unix Solaris 10 web server by the way. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: No ColdFusion Search Services
On windows go to the services applet and check to see that the coldfusion 9 solr service is running Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Thursday, July 29, 2010 11:57 AM To: cf-talk Subject: No ColdFusion Search Services I'm attempting to make my first application using the CF9 Solr search feature. So I logged into the Administrator to make a collection of some web directories, and I get this message: Unable to retrieve collections from any of the Search Services. Please verify that atleast one of ColdFusion Search Services are installed and running. I'm pretty sure we installed Solr when we did the installation, how would one go about checking that it is installed, running and healthy? This would be on a Unix Solaris 10 web server by the way. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: No ColdFusion Search Services
On 7/29/2010 10:20 AM, Mark A. Kruger wrote: On windows go to the services applet and check to see that the coldfusion 9 solr service is running I would have done that except... From: Ian Skinner [mailto:h...@ilsweb.com] This would be on a Unix Solaris 10 web server by the way. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: No ColdFusion Search Services
Doh! Ummm not sure on solaris... but there should be a start script in the bin directory Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Thursday, July 29, 2010 12:32 PM To: cf-talk Subject: Re: No ColdFusion Search Services On 7/29/2010 10:20 AM, Mark A. Kruger wrote: On windows go to the services applet and check to see that the coldfusion 9 solr service is running I would have done that except... From: Ian Skinner [mailto:h...@ilsweb.com] This would be on a Unix Solaris 10 web server by the way. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: A Better Coldfusion Search Form.
Hi Colin, Dont forget to use your cfqueryparam tags in your queries. -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303260 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: A Better Coldfusion Search Form.
And for Oracle: http://download.oracle.com/docs/cd/B19306_01/text.102/b14218/toc.htm http://download.oracle.com/docs/cd/B19306_01/text.102/b14217/toc.htm On Sun, Apr 13, 2008 at 4:16 AM, Scott Pinkston [EMAIL PROTECTED] wrote: Look up freetext or fulltext depending on the db engine. MySQL: http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html SQL Server: http://msdn2.microsoft.com/en-us/library/ms176078.aspx Hi, I'm trying to figure out how to create a dynamic search form using Coldfusion 8. Right now if I enter multiple words in my search field the results omit certain records. For example, if I put toy blue in the search field it will return results that only have TOY BLUE together and omits any records that only have TOY or only have Blue in the column being searched. Is there a way to add the following abilities to my basic search code located at the bottom of my post: - Search multiple words that are entered in the criteria input field. - The words can be separated by commas, spaces, or the word and. - Have it so you can search multiple word phrases by using quotes. !--- Search Form--- form name=myForm method=post action=results.cfm p input name=criteria type=text id=criteria input type=submit name=Submit value=Submit /p /form !--- Results Page --- cfquery name=qSearch datasource=myDatabase dbtype=ODBC SELECT itemID, itemName FROM myTable WHERE 1 = 1 cfif IsDefined(form.criteria) AND Len(Trim(form.criteria)) and (itemName LIKE '%#form.criteria#%' or itemDescription LIKE '%#form. criteria#%') /cfif /cfquery pbResults:/b/p cfoutput query=qSearch p#itemid# - #itemName#/p /cfoutput !- Any help would be greatly appreciated. Thanks -C ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
A Better Coldfusion Search Form.
Hi, I'm trying to figure out how to create a dynamic search form using Coldfusion 8. Right now if I enter multiple words in my search field the results omit certain records. For example, if I put toy blue in the search field it will return results that only have TOY BLUE together and omits any records that only have TOY or only have Blue in the column being searched. Is there a way to add the following abilities to my basic search code located at the bottom of my post: - Search multiple words that are entered in the criteria input field. - The words can be separated by commas, spaces, or the word and. - Have it so you can search multiple word phrases by using quotes. !--- Search Form--- form name=myForm method=post action=results.cfm p input name=criteria type=text id=criteria input type=submit name=Submit value=Submit /p /form !--- Results Page --- cfquery name=qSearch datasource=myDatabase dbtype=ODBC SELECT itemID, itemName FROM myTable WHERE 1 = 1 cfif IsDefined(form.criteria) AND Len(Trim(form.criteria)) and (itemName LIKE '%#form.criteria#%' or itemDescription LIKE '%#form.criteria#%') /cfif /cfquery pbResults:/b/p cfoutput query=qSearch p#itemid# - #itemName#/p /cfoutput !- Any help would be greatly appreciated. Thanks -C ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: A Better Coldfusion Search Form.
Something like this cfif IsDefined(form.criteria) AND Len(Trim(form.criteria)) and ( cfset c=0 cfloop index=wrd list=#form.criteria# delimiters= cfset c=c+1 itemName LIKE '%#wrd#%' cfif c neq listlen(form.criteria, ) OR /cfif /cfloop ) /cfif -Original Message- From: Colin Eyo [mailto:[EMAIL PROTECTED] Sent: Saturday, April 12, 2008 12:36 PM To: CF-Talk Subject: A Better Coldfusion Search Form. Hi, I'm trying to figure out how to create a dynamic search form using Coldfusion 8. Right now if I enter multiple words in my search field the results omit certain records. For example, if I put toy blue in the search field it will return results that only have TOY BLUE together and omits any records that only have TOY or only have Blue in the column being searched. Is there a way to add the following abilities to my basic search code located at the bottom of my post: - Search multiple words that are entered in the criteria input field. - The words can be separated by commas, spaces, or the word and. - Have it so you can search multiple word phrases by using quotes. !--- Search Form--- form name=myForm method=post action=results.cfm p input name=criteria type=text id=criteria input type=submit name=Submit value=Submit /p /form !--- Results Page --- cfquery name=qSearch datasource=myDatabase dbtype=ODBC SELECT itemID, itemName FROM myTable WHERE 1 = 1 cfif IsDefined(form.criteria) AND Len(Trim(form.criteria)) and (itemName LIKE '%#form.criteria#%' or itemDescription LIKE '%#form.criteria#%') /cfif /cfquery pbResults:/b/p cfoutput query=qSearch p#itemid# - #itemName#/p /cfoutput !- Any help would be greatly appreciated. Thanks -C ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: A Better Coldfusion Search Form.
Look up freetext or fulltext depending on the db engine. MySQL: http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html SQL Server: http://msdn2.microsoft.com/en-us/library/ms176078.aspx Hi, I'm trying to figure out how to create a dynamic search form using Coldfusion 8. Right now if I enter multiple words in my search field the results omit certain records. For example, if I put toy blue in the search field it will return results that only have TOY BLUE together and omits any records that only have TOY or only have Blue in the column being searched. Is there a way to add the following abilities to my basic search code located at the bottom of my post: - Search multiple words that are entered in the criteria input field. - The words can be separated by commas, spaces, or the word and. - Have it so you can search multiple word phrases by using quotes. !--- Search Form--- form name=myForm method=post action=results.cfm p input name=criteria type=text id=criteria input type=submit name=Submit value=Submit /p /form !--- Results Page --- cfquery name=qSearch datasource=myDatabase dbtype=ODBC SELECT itemID, itemName FROM myTable WHERE 1 = 1 cfif IsDefined(form.criteria) AND Len(Trim(form.criteria)) and (itemName LIKE '%#form.criteria#%' or itemDescription LIKE '%#form. criteria#%') /cfif /cfquery pbResults:/b/p cfoutput query=qSearch p#itemid# - #itemName#/p /cfoutput !- Any help would be greatly appreciated. Thanks -C ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
No ColdFusion Search Service
I just installed a copy of CF 7.01 to do some testing for a client migration from 5 to 7 and there is no search service installed. I installed it as a 30day trial and didn't get any errors in the installation log. anyone have any idea why i wouldn't have the search service? I need this to test the verity collection scritps they have on there site. TIA jonese ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223198 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: No ColdFusion Search Service
Search services and ODBC services are optional installation choices. I don't know if you can add them after the fact without doing a re-install. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223203 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: No ColdFusion Search Service
i've reinstalled twice and ensured that both were checked off each time... wierd! jonese On 11/4/05, Ian Skinner [EMAIL PROTECTED] wrote: Search services and ODBC services are optional installation choices. I don't know if you can add them after the fact without doing a re-install. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org http://www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: coldfusion search
I hope your database isn't large. This '%string%' can be slower than a teenager doing the dishes if your search set is large. I found that anything over 100,000 records got too slow for me, but I couldn't tell you what hardware I was running under at the time. On 7/25/02 4:40 PM, Benoit Martin [EMAIL PROTECTED] wrote: cfset WhereClause = WhereClause and Title like '% form.titleValue %' -Original Message- From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 1:04 PM To: CF-Talk Subject: coldfusion search Hi ... i am a newbie to CF ... I was wondering if some one could help me figure out how to make a search box that can do a contains search ... i can get the begins with and the equals, but not contains ... see below thanks! cfset WhereClause = 0=0 cfif Form.titleValue GT cfif Form.titleOperator EQ EQUALS cfset WhereClause = WhereClause and Title =' form.titleValue ' /cfif cfif Form.titleOperator EQ BEGINS_WITH cfset WhereClause = WhereClause and Title like ' form.titleValue %' cfelse cfset WhereClause = WhereClause and Title like ' form.titleValue WHAT DO I PUT HERE TO MAKE CONTAINS WORK? /cfif /cfif __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: coldfusion search
I hope your database isn't large. This '%string%' can be slower than a teenager doing the dishes if your search set is large. I found that anything over 100,000 records got too slow for me, but I couldn't tell you what hardware I was running under at the time. I second your suggestion. I see this all the time, and would generally recommend that you use Verity or some other full-text indexing at that point. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
coldfusion search
Hi ... i am a newbie to CF ... I was wondering if some one could help me figure out how to make a search box that can do a contains search ... i can get the begins with and the equals, but not contains ... see below thanks! cfset WhereClause = 0=0 cfif Form.titleValue GT cfif Form.titleOperator EQ EQUALS cfset WhereClause = WhereClause and Title =' form.titleValue ' /cfif cfif Form.titleOperator EQ BEGINS_WITH cfset WhereClause = WhereClause and Title like ' form.titleValue %' cfelse cfset WhereClause = WhereClause and Title like ' form.titleValue WHAT DO I PUT HERE TO MAKE CONTAINS WORK? /cfif /cfif __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: coldfusion search
cfset WhereClause = WhereClause and Title like '% form.titleValue %' -Original Message- From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 1:04 PM To: CF-Talk Subject: coldfusion search Hi ... i am a newbie to CF ... I was wondering if some one could help me figure out how to make a search box that can do a contains search ... i can get the begins with and the equals, but not contains ... see below thanks! cfset WhereClause = 0=0 cfif Form.titleValue GT cfif Form.titleOperator EQ EQUALS cfset WhereClause = WhereClause and Title =' form.titleValue ' /cfif cfif Form.titleOperator EQ BEGINS_WITH cfset WhereClause = WhereClause and Title like ' form.titleValue %' cfelse cfset WhereClause = WhereClause and Title like ' form.titleValue WHAT DO I PUT HERE TO MAKE CONTAINS WORK? /cfif /cfif __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: coldfusion search
marci beaucoup |-Original Message- |From: Benoit Martin [mailto:[EMAIL PROTECTED]] |Sent: Thursday, July 25, 2002 7:41 PM |To: CF-Talk |Subject: RE: coldfusion search | | |cfset WhereClause = WhereClause and Title like '% |form.titleValue |%' | | |-Original Message- |From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] |Sent: Thursday, July 25, 2002 1:04 PM |To: CF-Talk |Subject: coldfusion search | | |Hi ... i am a newbie to CF ... I was wondering if some one |could help me |figure out how to make a search box that can do a contains |search ... i |can get the begins with and the equals, but not contains ... see below |thanks! | |cfset WhereClause = 0=0 |cfif Form.titleValue GT | cfif Form.titleOperator EQ EQUALS | cfset WhereClause = WhereClause and Title =' |form.titleValue ' | /cfif | cfif Form.titleOperator EQ BEGINS_WITH | cfset WhereClause = WhereClause and Title like ' |form.titleValue %' | cfelse | cfset WhereClause = WhereClause and Title like ' |form.titleValue WHAT DO I PUT HERE TO MAKE CONTAINS |WORK? | /cfif |/cfif | | __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: coldfusion search
Il n'y pas de quoi ;-) -Original Message- From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 1:44 PM To: CF-Talk Subject: RE: coldfusion search marci beaucoup |-Original Message- |From: Benoit Martin [mailto:[EMAIL PROTECTED]] |Sent: Thursday, July 25, 2002 7:41 PM |To: CF-Talk |Subject: RE: coldfusion search | | |cfset WhereClause = WhereClause and Title like '% |form.titleValue |%' | | |-Original Message- |From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] |Sent: Thursday, July 25, 2002 1:04 PM |To: CF-Talk |Subject: coldfusion search | | |Hi ... i am a newbie to CF ... I was wondering if some one |could help me |figure out how to make a search box that can do a contains |search ... i |can get the begins with and the equals, but not contains ... see below |thanks! | |cfset WhereClause = 0=0 |cfif Form.titleValue GT | cfif Form.titleOperator EQ EQUALS | cfset WhereClause = WhereClause and Title =' |form.titleValue ' | /cfif | cfif Form.titleOperator EQ BEGINS_WITH | cfset WhereClause = WhereClause and Title like ' |form.titleValue %' | cfelse | cfset WhereClause = WhereClause and Title like ' |form.titleValue WHAT DO I PUT HERE TO MAKE CONTAINS |WORK? | /cfif |/cfif | | __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: coldfusion search
consider that the % sign is the wildcard match for ANSI SQL. if you put it after the search term in the LIKE clause (as you did with BEGINS_WITH), you search for something that has searchstringany characters. the any characters is the % sign. now, you want something that will match any characters before and after the search term. put the % on both sides of the search term. like so... cfset WhereClause = WhereClause and Title like '% form.titleValue %' -Original Message- From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:04 PM To: CF-Talk Subject: coldfusion search Hi ... i am a newbie to CF ... I was wondering if some one could help me figure out how to make a search box that can do a contains search ... i can get the begins with and the equals, but not contains ... see below thanks! cfset WhereClause = 0=0 cfif Form.titleValue GT cfif Form.titleOperator EQ EQUALS cfset WhereClause = WhereClause and Title =' form.titleValue ' /cfif cfif Form.titleOperator EQ BEGINS_WITH cfset WhereClause = WhereClause and Title like ' form.titleValue %' cfelse cfset WhereClause = WhereClause and Title like ' form.titleValue WHAT DO I PUT HERE TO MAKE CONTAINS WORK? /cfif /cfif __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists