I assume you're referring to SQL7's full-text search capability.
Remove these words before you submit the query.
I found SQL7's automatic "noise word" removal does not work as
advertised. So I made a table and added the noise words to it. I then
parse the submitted query and remove noise words from it. I notice M$
included SQL keywords in their list of noise words, so my solution already
achieves removal of SQL keywords.
Let me know if you'd like to see my CF script that does this.
(It was actually posted here a week or so ago.)
best, paul
At 07:53 PM 11/27/00 -0800, you wrote:
>Hi
>
>if any sql keywords are being typed in my search input box ...an error
>is generated as
>the sql statement contains the FreeTextTable function which is not accepting
>the sql keywords
>such as between,like,as... So iam getting an error....
>Is there anyway i con solve this problem...
>an early help will be just Great
>
>Regards
>Vikram
>
>__________________________________________________
>FREE voicemail, email, and fax...all in one place.
>Sign Up Now! http://www.onebox.com
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Structure your ColdFusion code with Fusebox. Get the official book at
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
