MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Develop Manual

Page: 283 / 860

Optimizing ColdFusion applications 283
For more information on creating stored procedures, see your database management software
documentation. For more information on using the
cfstoredproc
tag, see CFML Reference .
Using the cfquery tag cachedWithin attribute
The
cfquery
tag
cachedWithin
attribute tells ColdFusion to save the results of a database query
for a specific period of time. This way, ColdFusion accesses the database on the first page request,
and does not query the database on further requests until the specified time expires. Using the
cachedWithin
attribute can significantly limit the overhead of accessing databases that do not
change rapidly.
This technique is useful if the database contents only change at specific, known times, or if the
database does not change frequently and the purpose of the query does not require absolutely up-
to-date results.
<cfprocparam type = "IN"
CFSQLType = CF_SQL_INTEGER
value = "1" dbVarName = @param1>
<cfprocparam type = "OUT" CFSQLType =
CF_SQL_DATE
variable = FOO dbVarName = @param2>
</cfstoredproc>
Specifies two parameters for the stored
procedure, an input parameter and an output
parameter. Sets the input parameter to 1 and
the ColdFusion variable that gets the output
to FOO.
Ends the
cfstoredproc
tag body.
<cfoutput>
The output param value: ’#foo#’<br>
</cfoutput>
<h3>The Results Information</h3>
<cfoutput query = RS1>
#name#,#DATE_COL#<br>
</cfoutput>
<br>
<cfoutput>
<hr>
Record Count: #RS1.recordCount#<br>
Columns: #RS1.columnList#<br>
<hr>
</cfoutput>
<cfoutput query = RS3>
#col1#,#col2#,#col3#<br>
</cfoutput>
<br>
<cfoutput>
<hr><br>
Record Count: #RS3.recordCount#<br>
Columns: #RS3.columnList#<br>
<hr>
The return code for the stored procedure is:
’#cfstoredproc.statusCode#’<br>
</cfoutput>
Displays the results of running the stored
procedure:
•
The output parameter value,
• The contents of the two columns in the
first record set identified by the name and
DATE_COL variables. You set the values
of these variables elsewhere on the page.
• The number of rows and the names of the
columns in the first record set
•
The contents of the columns in the other
record set identified by the col1, col2, and
col3 variables.
•
The number of rows and the names of the
columns in the record set
•
The status value returned by the stored
procedure.
Code Description