I have created a search page using verity, I am having a hard time trying to put a condition.
I am showing the code below, when I enter some criteria in the form below, it is not getting searched.
Secondly I am confused as to whether we have to update the index as shown below every time we query , this is slowing down the results
<cfquery name="List" datasource="test">
select distinct iID,sRoguePassword from myusers
</cfquery>
<!---
<CFINDEX COLLECTION="test"
ACTION="Update"
TYPE="Custom"
KEY="iID"
BODY="sRoguePassword"
QUERY="List"
RECURSE="Yes"
EXTERNAL="Yes"
LANGUAGE="English"
>--->
<h2>Indexing Complete</h2>
<cfif isdefined("Form.FindMe" AND (Form.FindMe is not "">
<CFSEARCH
NAME="testSearch"
COLLECTION="Message"
TYPE="Simple"
CRITERIA="#Form.FindMe#">
<!---Available Match Information--->
<cfoutput query="testSearch">
Records Searched:#RECORDSSEARCHED#<br>
Returned:#RECORDCOUNT#<br>
URL #URL# <br>
KEY #KEY# <br>
row #CURRENTROW# <br>
Title#TITLE# <br>
Score#SCORE# <br>
Summary #SUMMARY#<br>
</cfoutput>
<hr>
</cfif>
<form action="veritytest2.cfm" method="post">
Search this site for:
<input type="text" name="FindMe">
<input type="submit" name="submit" value="GO">
</form>
I am showing the code below, when I enter some criteria in the form below, it is not getting searched.
Secondly I am confused as to whether we have to update the index as shown below every time we query , this is slowing down the results
<cfquery name="List" datasource="test">
select distinct iID,sRoguePassword from myusers
</cfquery>
<!---
<CFINDEX COLLECTION="test"
ACTION="Update"
TYPE="Custom"
KEY="iID"
BODY="sRoguePassword"
QUERY="List"
RECURSE="Yes"
EXTERNAL="Yes"
LANGUAGE="English"
>--->
<h2>Indexing Complete</h2>
<cfif isdefined("Form.FindMe" AND (Form.FindMe is not "">
<CFSEARCH
NAME="testSearch"
COLLECTION="Message"
TYPE="Simple"
CRITERIA="#Form.FindMe#">
<!---Available Match Information--->
<cfoutput query="testSearch">
Records Searched:#RECORDSSEARCHED#<br>
Returned:#RECORDCOUNT#<br>
URL #URL# <br>
KEY #KEY# <br>
row #CURRENTROW# <br>
Title#TITLE# <br>
Score#SCORE# <br>
Summary #SUMMARY#<br>
</cfoutput>
<hr>
</cfif>
<form action="veritytest2.cfm" method="post">
Search this site for:
<input type="text" name="FindMe">
<input type="submit" name="submit" value="GO">
</form>