Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
Altawan #1
CFSEARCH: retrieving rows when StartRow is not 1
We are moving an application from a server on CF 5 to one on CF MX 6.1. In a
verity search of a collection, we are displaying 10 hits at a time. If the hit
is more than 10 (i.e. we resubmit the form with a startRow of 11 or more) no
hits are returned with CF 6.1. In version 5, all subsequent requests for a
particular criteria, where we did not start with the default startRow = 1
worked. What is different in CF MX? Is there an example of how to move the
startRow along? I have attached the code with launches a request for the next
set of the hit list and the cfsearch tag that we are using. The startRow and
maxRow values are correctly being advanced.
<CFSEARCH
name = "GetResults"
collection = "#SearchCollection#"
criteria = "#s_Criteria#"
type="simple"
maxRows = "#Evaluate(Form.MaxRows)#"
startRow = "#Form.StartRow#">
<cfif (form.StartRow+9) lt GetResults_total.RecordCount>
<CFFORM name="More" action="SearchDecision_Action.cfm" method="post">
<CFOUTPUT>
<INPUT type="hidden" name="Criteria" value="#Replace(Form.Criteria, """",
"'", "ALL")#">
<INPUT type="hidden" name="MaxRows" value="#Form.MaxRows#">
<INPUT type="hidden" name="StartRow" value="#Evaluate(Form.StartRow +
Form.MaxRows)#">
<INPUT type="hidden" name="qry_searchsynopsis"
value="#Form.qry_searchsynopsis#">
<INPUT type="hidden" name="qry_searchcases"
value="#Form.qry_searchcases#">
<INPUT type="submit" value=" More ... ">
<input type="button" onclick="self.location.href ='Searchdecision.cfm'"
value="Search Again">
</CFOUTPUT>
</CFFORM>
<cfelse>
<cfform name="finished">
<input type="button" onclick="self.location.href ='Searchdecision.cfm'"
value="Search Again">
</cfform>
</CFIF>
Altawan Guest
-
CFsearch and Fusebox
Hi, Can anyone refer me to a simple application/ may be an example that is available and uses Fusebox and CFSeach. I'm hoping there should be... -
CFSEARCH issue
I am running into a brick wall with a fairly simple search interface I'm working on. Basically, I index a query and then run a CFSEARCH against the... -
CFSearch help
I just want to get CFSearch to return SOMETHING! I hate sounding like a whiner who doesn't read the documentation - I have. I've done the tutorials... -
How to sort CFSEARCH results
Was wondering if someone might know an easy way to sort the results of a CFSEARCH query. I can query the Verity collection created of documents,... -
How to generate datagrid without knowing # of rows (not retrieving form a database)
Hi all I'm trying to create form (can be anything, but a prefer it's a datagrid). It should look like this Header 1 Header 2 ...



Reply With Quote

