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?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
