--=====================_1016101==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
You could use a list function and a space delim " " to get each word from a
text box. then you can do any kind of search you like with each word if you
are not looking for an exact phrase.
Does that make sense?
At 06:49 PM 28/03/00 -0500, you wrote:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0157_01BF98E6.A3149B80
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>I know this is probably a really dumb question, but how can I make CF =
>search a database field using more than a single word typed into a =
>search box?
>
>E.G.; Search: intel ghz
>
>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:=20
>
>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>
>
>Thanks for any help.
>
>-Ryan Shrout
>Power Gamerz; K7M.COM
>[EMAIL PROTECTED]
>
>------=_NextPart_000_0157_01BF98E6.A3149B80
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>I know this is probably a really dumb = question, but=20 how can I make CF
>search a database field using more than a single word = typed=20 into a
>search box?
>
>E.G.; Search: intel ghz
>
>The title of a news entry in my = database is "Intel=20 Pentium III 1 GHz
>Now Available" but it won't find and return this = entry. =20 However if
>the search is like this:
>
>E.G.; = Search:=20 intel
>
>It DOES find the word intel and returns = the correct=20 results. Here is
>the CFQUERY code:
>
><CFQUERY Datasource=3D"Athlonmb"=20 Name=3D"NewsResults">
> SELECT Title, NewsID, = Date
> FROM=20 News
> WHERE (Title LIKE '%#SearchText#%')
> ORDER BY Date = DESC
></cfquery>
>
>Thanks for any help.
>
>-Ryan Shrout
>Power Gamerz; = K7M.COM
><3d.htm>[EMAIL PROTECTED]
>
>------=_NextPart_000_0157_01BF98E6.A3149B80--
>
>------------------------------------------------------------------------------
>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.
--=====================_1016101==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
You could use a list function and a space delim " " to get each
word from a text box. then you can do any kind of search you like with
each word if you are not looking for an exact phrase.<br>
<br>
Does that make sense?<br>
<br>
<br>
At 06:49 PM 28/03/00 -0500, you wrote:<br>
<blockquote type=cite cite>This is a multi-part message in MIME
format.<br>
<br>
------=_NextPart_000_0157_01BF98E6.A3149B80<br>
Content-Type: text/plain;<br>
<x-tab> </x-tab>charset="iso-8859-1"<br>
Content-Transfer-Encoding: quoted-printable<br>
<br>
I know this is probably a really dumb question, but how can I make CF
=<br>
search a database field using more than a single word typed into a
=<br>
search box?<br>
<br>
E.G.; Search: intel ghz<br>
<br>
The title of a news entry in my database is "Intel Pentium III 1 GHz
Now =<br>
Available" but it won't find and return this entry. However if
the =<br>
search is like this:=20<br>
<br>
E.G.; Search: intel<br>
<br>
It DOES find the word intel and returns the correct results. Here
is =<br>
the CFQUERY code:<br>
<br>
<CFQUERY Datasource=3D"Athlonmb"
Name=3D"NewsResults"><br>
SELECT Title, NewsID, Date<br>
FROM News<br>
WHERE (Title LIKE '%#SearchText#%')<br>
ORDER BY Date DESC<br>
</cfquery><br>
<br>
Thanks for any help.<br>
<br>
-Ryan Shrout<br>
Power Gamerz; K7M.COM<br>
[EMAIL PROTECTED]<br>
<br>
------=_NextPart_000_0157_01BF98E6.A3149B80<br>
Content-Type: text/html;<br>
<x-tab> </x-tab>charset="iso-8859-1"<br>
Content-Transfer-Encoding: quoted-printable<br>
<br>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN"><br>
I know this is probably a really dumb = question, but=20 how can I make
CF search a database field using more than a single word = typed=20 into
a search box?<br>
<br>
E.G.; Search: intel ghz<br>
<br>
The title of a news entry in my = database is "Intel=20 Pentium III
1 GHz Now Available" but it won't find and return this = entry. =20
However if the search is like this: <br>
<br>
E.G.; = Search:=20 intel<br>
<br>
It DOES find the word intel and returns = the correct=20 results.
Here is the CFQUERY code:<br>
<br>
<CFQUERY Datasource=3D"Athlonmb"=20
Name=3D"NewsResults"><br>
SELECT Title, NewsID, = Date<br>
FROM=20 News<br>
WHERE (Title LIKE '%#SearchText#%')<br>
ORDER BY Date = DESC<br>
</cfquery><br>
<br>
Thanks for any help.<br>
<br>
-Ryan Shrout<br>
Power Gamerz; = K7M.COM<br>
<a href="3d.htm">[EMAIL PROTECTED]</a><br>
<br>
------=_NextPart_000_0157_01BF98E6.A3149B80--<br>
<br>
------------------------------------------------------------------------------<br>
Archives:
<a href="http://www.egroups.com/list/cf-talk"
eudora="autourl">http://www.eGroups.com/list/cf-talk</a><br>
To Unsubscribe visit
<a href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.</blockquote></html>
--=====================_1016101==_.ALT--
------------------------------------------------------------------------------
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.
