On 3/28/00, Ryan Shrout penned:
>The title of a news entry in my database is "Intel Pentium III 1 GHz Now
>Available" but it won't find and return this entry. However if the
>search is like this:
>
>E.G.; Search: intel
>
>It DOES find the word intel and returns the correct results. Here is
>the CFQUERY code:
>
><CFQUERY Datasource=3D"Athlonmb" Name=3D"NewsResults">
> SELECT Title, NewsID, Date
> FROM News
> WHERE (Title LIKE '%#SearchText#%')
> ORDER BY Date DESC
></cfquery>
The only reason I can think that a search for "Intel Pentium", etc.,
wouldn't be returned is that you are submitting the form via GET
rather than POST and the string becomes "Intel+Pentium".
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
