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
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
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
