<!--- This example shows how to use the CFQUERYPARAM tag --->

<HTML>

<HEAD>

<TITLE>
CFQUERYPARAM Example
</TITLE>

</HEAD>

<BASEFONT FACE="Arial, Helvetica" SIZE=2>
<BODY  bgcolor="#FFFFD5">

<H3>CFQUERYPARAM Example</H3>

<!---------------------------------------------------------------------- 
This example shows the use of CFQUERYPARAM when invalid string data is 
in Course_ID. 
----------------------------------------------------------------------->
<HTML>
<HEAD>
<TITLE>CFQUERYPARAM Example</TITLE>
</HEAD>

<BODY>
<h3>CFQUERYPARAM Example with Bad String Input</h3>

<CFSET LastName="Peterson; DELETE employees WHERE LastName='Peterson'">
<-----------------------------------------------------------------------
Note that for string input you must specify the MAXLENGTH attribute for 
validation.
----------------------------------------------------------------------->
<CFQUERY NAME="getFirst" DATASOURCE="cfsnippets">
	SELECT * 
	FROM employees
	WHERE LastName=<CFQUERYPARAM VALUE="#LastName#"
	CFSQLType="CF_SQL_VARCHAR" 
	MAXLENGTH="17">
</CFQUERY>
<CFOUTPUT QUERY="getFirst">
<P>Course Number: #FirstName# #LastName#
 Description: #Department#
</P>
</CFOUTPUT>
</BODY>
</HTML>


   
