home *** CD-ROM | disk | FTP | other *** search
/ Chip 2002 February / CHIPCD_02_2002.iso / Internet / Macromedia ColdFusion Server 5 / coldfusion-50-win-us.exe / data1.cab / Examples / CFDOCS / snippets / cfqueryparam.cfm < prev    next >
Encoding:
Text File  |  2001-06-13  |  1.2 KB  |  52 lines
  1. <!--- This example shows how to use the CFQUERYPARAM tag --->
  2.  
  3. <HTML>
  4.  
  5. <HEAD>
  6.  
  7. <TITLE>
  8. CFQUERYPARAM Example
  9. </TITLE>
  10.  
  11. </HEAD>
  12.  
  13. <BASEFONT FACE="Arial, Helvetica" SIZE=2>
  14. <BODY  bgcolor="#FFFFD5">
  15.  
  16. <H3>CFQUERYPARAM Example</H3>
  17.  
  18. <!---------------------------------------------------------------------- 
  19. This example shows the use of CFQUERYPARAM when invalid string data is 
  20. in Course_ID. 
  21. ----------------------------------------------------------------------->
  22. <HTML>
  23. <HEAD>
  24. <TITLE>CFQUERYPARAM Example</TITLE>
  25. </HEAD>
  26.  
  27. <BODY>
  28. <h3>CFQUERYPARAM Example with Bad String Input</h3>
  29.  
  30. <CFSET LastName="Peterson; DELETE employees WHERE LastName='Peterson'">
  31. <-----------------------------------------------------------------------
  32. Note that for string input you must specify the MAXLENGTH attribute for 
  33. validation.
  34. ----------------------------------------------------------------------->
  35. <CFQUERY NAME="getFirst" DATASOURCE="cfsnippets">
  36.     SELECT * 
  37.     FROM employees
  38.     WHERE LastName=<CFQUERYPARAM VALUE="#LastName#"
  39.     CFSQLType="CF_SQL_VARCHAR" 
  40.     MAXLENGTH="17">
  41. </CFQUERY>
  42. <CFOUTPUT QUERY="getFirst">
  43. <P>Course Number: #FirstName# #LastName#
  44.  Description: #Department#
  45. </P>
  46. </CFOUTPUT>
  47. </BODY>
  48. </HTML>
  49.  
  50.  
  51.    
  52.