MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Develop Manual

Page: 459 / 860

About Query of Queries 459
<tr>
<td colspan = 4>
<cfif (st maxrows) lte getsals2.recordcount>
<a href="qoq_next_row.cfm?startrow=<cfoutput>#Evaluate(St
MaxRows)#</cfoutput>">See next <cfoutput>#MaxRows#</cfoutput>
rows</a>
</cfif>
</td>
</tr>
</table>
</body>
</html>
2
Save the page as qoq_next_row.cfm in the myapps directory under the web_root
.
3
In your web browser, enter the following URL to display the query results:
http://127.0.0.1/myapps/qoq_next_row.cfm
The following figure shows how the output appears:
Using the cfdump tag with query results
As you debug your CFML code, you can use the
cfdump
tag to quickly present the value of your
query. This tag has the following format:
<cfdump var="#query_name#">
For more information on the
cfdump
tag, see CFML Reference .
Using Query of Queries with non-SQL record sets
A Query of Queries can operate on any CFML tag or function that returns a record set; you are
not limited to operating on
cfquery
results. You can perform queries on non-SQL record sets,
such as a
cfdirectory
tag, Verity searches, a
cfldap
tag, and so on.
The following example shows how a Query of Queries interacts with the record set of a Verity
search. This example assumes that you have a valid Verity collection, called bbb, which contains
documents with a target word, film, or its variants (films, filmed, filming). Change the name of
the collection and the search criteria to as appropriate for your Verity collection. For more
information on Verity, see
Chapter 24, “Building a Search Interface,” on page 505 .