• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Name

cfqueryparam

Synopsis

<cfquery>
SQL statements
  [<cfqueryparam>]
</cfquery>

Checks the datatype and optionally validates a query parameter within the SQL statement of a cfquery tag. Multiple cfqueryparam tags may be used with a single cfquery tag.

The SQL that is generated by the cfqueryparam tag is dependent on the database used. If the database being used doesn’t support bind parameters, validation is still performed with the validated parameter being written back to the string. If for any reason validation fails, ColdFusion throws an exception. The following rules determine the validation performed:

  • cf_sql_smallint, cf_sql_integer, cf_sql_real, cf_sql_float, cf_sql_double, cf_sql_tinyint, cf_sql_money,


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint