Denny, the LIKE will not work, it work on strings, you need to tokenize your
strings and use each of the tokenized strings in a separate WHERE clause.
i.e. FORM.Criteria = "C++,Java"
Tokens your looking for
WHERE (blah like '%C++%')
AND (blah LIKE '%Java%')
Right??
Well you could write the tokenizing logic (split on whitespace and commas,
etc.) and dynamically write the SQL, or.... Why can't you just use Verity to
index the column containing the search criteria and let Verity handle the
searching?
-Sean
___________________________________________
Sean Brown <[EMAIL PROTECTED]>
http://www.westcar.com/
"Either way you get your dog back"
-Anonymous
___________________________________________
-----Original Message-----
From: Denny dd [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 05, 2000 12:51 AM
To: [EMAIL PROTECTED]
Subject: RE: Problem in search form
Hi!
Ramesh
Your suggestion is of no use.
The code u have written gives the same result
Denny
Deva Ramesh <[EMAIL PROTECTED]> wrote:
hai just try with this action page code
ACTION FORM
<HTML><HEAD><CFQUERY NAME="GetResults" DATASOURCE="PRJreq">
SELECT Req_No,Clt_Code
FROM Requirement
WHERE Req_Descript LIKE '%#Form.Criteria#%'
</CFQUERY>
ramesh
-----Original Message-----
From: Denny dd [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 11:29 PM
To: [EMAIL PROTECTED]
Subject: Problem in search form
Hi!
Every one
Here I have a Search form but its not working properly.The problem is that
when ever I submit exact keywords as stored in my database,for example say
"Java,C++" is stored in my database.
So where ever there is "Java,C++" the search engine will work but if I
submit
keywords in different way like "C++,Java" ,then it shows no records
available.
And can any one tell me that can I use radio button for options like
1)Exact words
2)Any words
3)Exact phrase
for the search engine.
CODE >>>
SEARCH FORM
</HEAD>
<BODY>
<h3><font color="#000000">Please enter keywords to search for.</font></h3>
<FORM ACTION="srchtest2.cfm" METHOD="POST">
Keywords: <INPUT TYPE="text" NAME="Criteria"><BR>
<P>
<INPUT TYPE="submit" VALUE="Search">
</FORM>
</BODY>
</HTML>
ACTION FORM
<HTML><HEAD><CFQUERY NAME="GetResults" DATASOURCE="PRJreq">
SELECT Req_No,Clt_Code
FROM Requirement
WHERE (Req_Descript LIKE '%#Form.Criteria#%')
</CFQUERY>
<TITLE>Search Results</TITLE>
</HEAD>
<BODY>
<h3><CFOUTPUT>#GetResults.RecordCount# Requirements found for
"#Form.Criteria#".</CFOUTPUT></h3>
<table width="52%" border="0">
<tr>
<td width="29%">Requirment no</td>
<td width="71%">Client code</td>
</tr>
<tr>
<td width="29%" height="35">
<h3><cfoutput query="GetResults">
</cfoutput></h3>
<ul>
<cfoutput query="GetResults"><li>#Req_No#
</cfoutput>
</ul></td>
<td width="29%" height="35">
<h3><cfoutput query="GetResults">
</cfoutput></h3>
<ul>
<cfoutput query="GetResults"><li>#Clt_Code#
</cfoutput> </ul>
</td>
</tr>
</table>
</BODY>
</HTML>
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
----------------------------------------------------------------------------
--
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.
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar�sts&body�sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
