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

Name

cfprocparam

Synopsis

                  <cfstoredproc>
  [<cfprocparam>]
  [<cfprocresult>]
  ...
</cfstoredproc>

Specifies parameter information to send to a stored procedure. cfprocparam tags are nested within a cfstoredproc tag.

Attributes

cfsqltype=" parameter_data_type "

The SQL type of the parameter being passed to the stored procedure. Required. The default is cf_sql_char. Possible values are cf_sql_bigint, cf_sql_bit, cf_sql_blob, cf_sql_char, cf_sql_clob, cf_sql_date, cf_sql_decimal, cf_sql_double, cf_sql_float, cf_sql_idstamp, cf_sql_integer, cf_sql_longvarchar, cf_sql_money, cf_sql_money4, cf_sql_numeric, cf_sql_real, cf_sql_refcursor (Oracle only), cf_sql_smallint, cf_sql_time, cf_sql_timestamp, cf_sql_tinyint, and cf_sql_varchar.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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