Kristine, besides Teddy's helpful info today, had you seen my reply to your
note from over the weekend, attached?
/charlie
From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Kristine
Sent: Monday, February 08, 2010 12:50 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] C# question clarified
I'm pretty desparate to try to search on a keyword called "C#". I'm using a
coldfusion page that grabs a bunch of variables and puts them all together
in a series of statements that gets pushed straight into a CFQUERY command
when the #strkeywords# variable is put into the statement it contains the
keyword 'C#' because I've changed C# to C## which the page then reads as C#.
However, what used to work (I think we use CF 8.0) doesn't anymore and it's
completely ignoring the # part and sees only the 'C' which it then kicks
back as a noise word.
Yuck.
Can anyone help guide me out there?
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
--- Begin Message ---
Kristine, you may want to clarify what's doing the searching. We'll assume
you're talking about a CF page, but are you using Verity? Solr (new in CF9)?
SQL Server's text searching? Plain SQL? It may help for us to know.
While we await that, I have a thought: since you say that c## became c# (in
the past), that sounds like CFML processing the variable, since it escapes
two #s to become one. When you say it "now sees only C", I would wonder
again if something else is at play there. Can you output the variable before
you pass it to whatever search engine you use, to see what the real value is
going into it?
/charlie
From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Kristine
Sent: Friday, February 05, 2010 10:13 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] C# keyword search problem
We had a problem before doing a keyword search on C# before and fixed it by
changing the search from c# to C##. Now, however, it seems to be completely
ignoring the ## and the query sees only 'C' in the search and therefore
throws a "noise word" error.
Can anyone suggest how we can solve our problem so we can search for the
keyword "C#" ?
kristine
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
--- End Message ---