| Tag | Attribute | Value | 4.0.1 | 4.5.0 | 4.5.1 | 5 | MX | MX 6.1 |
|---|---|---|---|---|---|---|---|---|
| cfprocparam | •
|
•
|
•
|
A
|
A
|
• |
||
type |
•
Opt |
•
Opt |
•
Opt |
•
Opt |
•
Opt |
•
Opt |
||
| in | •
Default |
•
Default |
•
Default |
•
Default |
•
Default |
•
Default |
||
| out | •
|
•
|
•
|
•
|
•
|
•
|
||
| inout | •
|
•
|
•
|
•
|
•
|
•
|
||
variable |
•
Req/Opt |
•
Req/Opt |
•
Req/Opt |
•
Req/Opt |
•
Req/Opt |
•
Req/Opt |
||
dbVarName |
•
Req/Opt |
•
Req/Opt |
•
Req/Opt |
•
Req/Opt |
O
|
O |
||
value |
•
Req/Opt |
•
Req/Opt |
•
Req/Opt |
•
Req/Opt |
•
Req/Opt |
•
Req/Opt |
||
CFSQLType |
•
Req |
•
Req |
•
Req |
•
Req |
•
Req |
•
Req |
||
| CF_SQL_BIGINT | •
|
•
|
•
|
•
|
•
|
•
|
||
| CF_SQL_BIT | •
|
•
|
•
|
•
|
•
|
•
|
||
| CF_SQL_BLOB | N
|
•
|
||||||
| CF_SQL_CHAR | •
|
•
|
•
|
•
|
•
|
•
|
||
| CF_SQL_CLOB | N
|
•
|
||||||
| 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 | N
|
•
|
•
|
|||||
| CF_SQL_SMALLINT | •
|
•
|
•
|
•
|
•
|
•
|
||
| CF_SQL_TIME | •
|
•
|
•
|
•
|
•
|
•
|
||
| CF_SQL_TIMESTAMP | •
|
•
|
•
|
•
|
•
|
•
|
||
| CF_SQL_TINYINT | •
|
•
|
•
|
•
|
•
|
•
|
||
| CF_SQL_VARCHAR | •
|
•
|
•
|
•
|
•
|
•
|
||
maxLength |
•
Opt |
•
Opt |
•
Opt |
•
Opt |
•
Opt |
•
Opt |
||
maxRows |
•
Opt |
•
Opt |
•
Opt |
•
Opt |
O
|
O |
||
| scale | •
Opt |
•
Opt |
•
Opt |
•
Opt |
•
Opt |
•
Opt |
||
null |
•
Opt |
•
Opt |
•
Opt |
•
Opt |
•
Opt |
•
Opt |
||
| yes | •
|
•
|
•
|
•
|
•
|
•
|
||
| no | •
Default |
•
Default |
•
Default |
•
Default |
•
Default |
•
Default |
||