RE: [ACFUG Discuss] C# question clarified
Kristine, I think I may have a solution for you, but I doubt it's a CF problem. First, you're saying this is just being passed into a query, by which I assume you mean a CFQUERY. But you said in your original note that it throws a noise word error. Is that in reference to SQL Server's full text searching? I had asked in my first reply if you were referring to this, or perhaps Verity, or Solr, etc. It helps to know these things in helping solve a problem. Assuming that it's SQL Server's full text search, I've seen some indications that the issue is that it regards the # as punctuation, which it ignores. That generally would be no problem, as it's good for search engines to find words regardless of how punctuation us used (both due to how the searched text may have it, and how one may think to write a search query). But in your example you're left only with the letter C, and apparently it considers that a noise word (too frequent to index). Looking into it a little for you, I find there are various solutions. On the surface, some assert that you could remove that c from the noise word file, since you DO want to find results searching just for that value. There seem even to be variations of SQL that may work differently (the LIKE keyword vs the FREETEXT function), as well as a matter of whether you're searching with US English or Neutral language. But for this specific term, c#, it turns out there may be a solution in a specific update to SQL Server to recognize it, though it seems it may depend on whether you are searching c# or C#. Perhaps one of the ideas above will be a good solution for you. Here are a few places that discuss it more: http://stackoverflow.com/questions/1042/why-doesnt-sql-full-text-indexing-re turn-results-for-words-containing http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search- language-features/ (Search for c# on the page to find the relevant discussion) http://www.eggheadcafe.com/software/aspnet/29440435/c-in-freetext.aspx I'll add that I found these by googling: sql server text c# noise word I just suggest that because you may have reasonably doubted if searching google for any specific failing phrase would have found much (since it seems a generic sql search problem), but because that specific phrase (c#) is not only a common one where this problem would occur, but more specifically since it turns out there's specific changes in SQL Server to help with searching this very term, it proved fruitful that I tried. :-) Let us know if any of those solve it for you. /charlie PS I hope this note will come through as I send it today, Wed at 2:05pm ET). :-) -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of techsupport Sent: Tuesday, February 09, 2010 8:25 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] C# question clarified I'm the original poster. I didn't get the first, but appreciate any help so thanks for resending it. I'm still confounded by it but I'm afraid I'll have to create a new way to write the search. That would be bad. yes, the keyword of C# is being passed as a variable into the query. I remember years ago being very frustrated years ago why my search was bombing when i passed variables into the query until I learned about the very clever preservesinglequotes command. I guess I'm hoping there's something similar that'll work for this. No?? - 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 -
Re: [ACFUG Discuss] C# question clarified
Charlie, Confirmed on email reception. Teddy
Re: [ACFUG Discuss] C# question clarified
I'm the original poster. I didn't get the first, but appreciate any help so thanks for resending it. I'm still confounded by it but I'm afraid I'll have to create a new way to write the search. That would be bad. yes, the keyword of C# is being passed as a variable into the query. I remember years ago being very frustrated years ago why my search was bombing when i passed variables into the query until I learned about the very clever preservesinglequotes command. I guess I'm hoping there's something similar that'll work for this. No?? -Original message- From: Robert Lash rl.xe...@gmail.com Date: Mon, 08 Feb 2010 16:01:33 -0500 To: discussion@acfug.org Subject: Re: [ACFUG Discuss] C# question clarified I too received Charlies responses to this. Was awaiting further info from original poster RL On Mon, Feb 8, 2010 at 3:25 PM, Clarke Bishop cbis...@resultantsys.comwrote: I did actually get Charlie's original message! I think there were some recent problems with the email server that may have caused some strange glitches! Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Cameron Childress Sent: Monday, February 08, 2010 3:10 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] C# question clarified On Mon, Feb 8, 2010 at 2:50 PM, Teddy R. Payne teddyrpa...@gmail.com wrote: Charlie, That is bizarre. I do not have record of your email on this conversation chain. I was feeling bad that I only noticed that Kristen got a response today as she was asking about it several days ago. I don't see it either, though the headers seem to indicate that Charlie got it back from the list as a message. It's also not in my Spam Bin... -Cameron ... - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.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 - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.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 - - 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 -
Re: [ACFUG Discuss] C# question clarified
Kristine, Are you trying to search through a string variable for a string pattern of C#? Then after you find it, you are putting C# into a query call? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Mon, Feb 8, 2010 at 12:49 PM, Kristine techsupp...@hirenet.net wrote: 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 -
Re: [ACFUG Discuss] C# question clarified
Kristine, I had a follow up though. How is the variable or string that you are searching through created? If the string is not created by ColdFusion, it probably makes it a little easier. If you are generating the string, you will have to make sure that you escape the string before you start searching through it. I am not sure if this helps, but an example is the following: cfset foo = This is a sentence with C## in it. / The variable foo becomes the sentence: This is a sentence with C# in it. To prove this: cfoutput #Find(C#chr(35)#, foo)#br / #Find(C#chr(35)##chr(35)#, foo)#br / /cfoutput Note: #chr(35)# gets the # symbol by calling it from the ASCII table. Now the first line in the cfoutput evaluates to a number where the first instance of C# occurs, which is 25. The second line is looking for C##, and this returns 0, which means an instance of the sub-string was not found. I know this example is really simple and I apologize if this over simplifies the issue, but I wanted to bring awareness to problem from how your search string is created and what you are trying to do with it afterward. Many problems I have to deal with have a source that may not be in the same location of the error or abhorrent behavior. Follow the code from the source of data and stepping over the application to watch for how your code manipulates the data could provide better introspection to the overall problem. HTH, Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Mon, Feb 8, 2010 at 12:56 PM, Teddy R. Payne teddyrpa...@gmail.comwrote: Kristine, Are you trying to search through a string variable for a string pattern of C#? Then after you find it, you are putting C# into a query call? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Mon, Feb 8, 2010 at 12:49 PM, Kristine techsupp...@hirenet.net wrote: 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 -
RE: [ACFUG Discuss] C# question clarified
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 - ---BeginMessage--- 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---
Re: [ACFUG Discuss] C# question clarified
Charlie, That is bizarre. I do not have record of your email on this conversation chain. I was feeling bad that I only noticed that Kristen got a response today as she was asking about it several days ago. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Mon, Feb 8, 2010 at 2:47 PM, Charlie Arehart char...@carehart.orgwrote: 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 FusionLink http://www.fusionlink.com -
Re: [ACFUG Discuss] C# question clarified
On Mon, Feb 8, 2010 at 2:50 PM, Teddy R. Payne teddyrpa...@gmail.com wrote: Charlie, That is bizarre. I do not have record of your email on this conversation chain. I was feeling bad that I only noticed that Kristen got a response today as she was asking about it several days ago. I don't see it either, though the headers seem to indicate that Charlie got it back from the list as a message. It's also not in my Spam Bin... -Cameron ... - 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 -
RE: [ACFUG Discuss] C# question clarified
Well, I will note that the forwarded message I attached was not from my “sent” folder but instead from my “acfug discuss” folder, so I had received it back via the list. I also just confirmed that it’s listed in the list archive: http://www.mail-archive.com/discussion%40acfug.org/msg06059.html, showing as have arrived on Saturday. I just would be bummed if she and you (and perhaps others) never got it, when it did seem to get through the list. :-( Things have been a little off lately, as last week I had several messages arrive hours or even days after I’d sent them to this list. John confirmed there was something to explain that. Maybe he’ll have a thought on this. But I’ll note as well that if one doesn’t rules and folders to push list messages into a folder, it’s also easy for any one email to slip by unnoticed. I can’t say enough good things about the value of rules and folders in managing lists, especially multiple of them. :-) I wrote a blog entry on the topic in 2002, for those who may still not use rules and folders for lists: http://cfmxplus.blogspot.com/2002/11/managing-mailing-list-messages-with.html Even now several years old, the steps discussed work fine in later versions of Outlook, and the concepts would apply to any email client. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Teddy R. Payne Sent: Monday, February 08, 2010 2:50 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] C# question clarified Charlie, That is bizarre. I do not have record of your email on this conversation chain. I was feeling bad that I only noticed that Kristen got a response today as she was asking about it several days ago. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Mon, Feb 8, 2010 at 2:47 PM, Charlie Arehart char...@carehart.org wrote: Kristine, besides Teddy’s helpful info today, had you seen my reply to your note from over the weekend, attached? /charlie - 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 -
RE: [ACFUG Discuss] C# question clarified
I did actually get Charlie's original message! I think there were some recent problems with the email server that may have caused some strange glitches! Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Cameron Childress Sent: Monday, February 08, 2010 3:10 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] C# question clarified On Mon, Feb 8, 2010 at 2:50 PM, Teddy R. Payne teddyrpa...@gmail.com wrote: Charlie, That is bizarre. I do not have record of your email on this conversation chain. I was feeling bad that I only noticed that Kristen got a response today as she was asking about it several days ago. I don't see it either, though the headers seem to indicate that Charlie got it back from the list as a message. It's also not in my Spam Bin... -Cameron ... - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.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 - - 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 -
Re: [ACFUG Discuss] C# question clarified
I too received Charlies responses to this. Was awaiting further info from original poster RL On Mon, Feb 8, 2010 at 3:25 PM, Clarke Bishop cbis...@resultantsys.comwrote: I did actually get Charlie's original message! I think there were some recent problems with the email server that may have caused some strange glitches! Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Cameron Childress Sent: Monday, February 08, 2010 3:10 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] C# question clarified On Mon, Feb 8, 2010 at 2:50 PM, Teddy R. Payne teddyrpa...@gmail.com wrote: Charlie, That is bizarre. I do not have record of your email on this conversation chain. I was feeling bad that I only noticed that Kristen got a response today as she was asking about it several days ago. I don't see it either, though the headers seem to indicate that Charlie got it back from the list as a message. It's also not in my Spam Bin... -Cameron ... - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.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 - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.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 -