172
CFML Language Reference
For a Sybase11 data source, the syntax of the SQL statement is as follows:
SELECT *
FROM courses
WHERE col1=10
Example
<!--------------------------------------------------------------------
This example shows the use of CFQUERYPARAM when valid input is given in
Course_ID.
----------------------------------------------------------------------->
<HTML>
<HEAD>
<TITLE>CFQUERYPARAM Example</TITLE>
</HEAD>
<BODY>
<h3>CFQUERYPARAM Example</h3>
<CFSET Course_ID=12>
<CFQUERY NAME="getFirst" DATASOURCE="cfsnippets">
SELECT *
FROM courses
WHERE Course_ID=<CFQUERYPARAM VALUE="#Course_ID#"
CFSQLType="CF_SQL_INTEGER">
</CFQUERY>
<CFOUTPUT QUERY="getFirst">
<P>Course Number: #number#<br>
Description: #descript#
</P>
</CFOUTPUT>
</BODY>
</HTML>
<!----------------------------------------------------------------------
This example shows the use of CFQUERYPARAM when invalid numeric data is
in Course_ID.
----------------------------------------------------------------------->
<HTML>
<HEAD>
<TITLE>CFQUERYPARAM Example</TITLE>
</HEAD>
<BODY>
<h3>CFQUERYPARAM Example With Bad Numeric Data</h3>
<CFSET Course_ID="12; DELETE courses WHERE Course_ID=20">
<CFQUERY NAME="getFirst" DATASOURCE="cfsnippets">
SELECT *
FROM courses
WHERE Course_ID=<CFQUERYPARAM VALUE="#Course_ID#"
CFSQLType="CF_SQL_INTEGER">
</CFQUERY>
<CFOUTPUT QUERY="getFirst">
<P>Course Number: #number#<br>
Description: #descript#
</P>
Summary of Contents for COLDFUSION 4.5-CFML LANGUAGE
Page 1: ...Allaire Corporation CFML Language Reference ColdFusion 4 5...
Page 207: ...Chapter 1 ColdFusion Tags 183 CFCATCH CFTRY BODY HTML...
Page 224: ...200 CFMLLanguageReference CFOUTPUT P Text within CFOUTPUT is always shown CFOUTPUT BODY HTML...
Page 336: ...312 CFMLLanguageReference CFIF BODY HTML...
Page 404: ...380 CFMLLanguageReference DE It is morning CFOUTPUT P BODY HTML...
Page 413: ...Chapter 2 ColdFusion Functions 389 Customer BalanceDue BR CFOUTPUT CFIF BODY HTML...
Page 483: ...Chapter 2 ColdFusion Functions 459 CFOUTPUT CFLOOP BODY HTML...
Page 584: ...560 CFMLLanguageReference...
Page 594: ...570 CFMLLanguageReference...
