MACROMEDIA COLDFUSION 5-CFML, Быстрая справка

Страница: 13 / 36

CFML Quick Reference 9
timeout = "seconds"
maxRows = "number"
startRow = "number"
generateUniqueFilenames = "boolean">
cfprocessingdirective
<cfprocessingdirective
suppressWhiteSpace = "Yes" or "No">
… any CFML tags here …
</cfprocessingdirective>
cfprocparam
<cfprocparam type = "IN or OUT or INOUT"
variable = "variable name"
dbVarName = "DB variable name"
value = "parameter value"
CFSQLType = "parameter datatype"
maxLength = "length"
scale = "decimal places"
null = "Yes" or "No">
cfprocresult
<cfprocresult name = "query_name"
resultSet = "1-n"
maxRows = "maxrows">
cfquery
<cfquery name = "query_name"
dataSource = "ds_name"
dbType = "type"
dbServer = "dbms"
dbName = "database name"
connectString = "connection string"
username = "username"
password = "password"
maxRows = "number"
blockFactor = "blocksize"
timeout = "milliseconds"
cachedAfter = "date"
cachedWithin = "timespan"
provider = "COMProvider"
providerDSN = "datasource"
debug>
SQL statements
</cfquery>
cfqueryparam
<cfquery name = "query_name"
dataSource = "ds_name"
...other attributes... >
SELECT STATEMENT WHERE column_name =
<cfqueryPARAM value = "parameter value"
CFSQLType = "parameter type"
maxLength = "maximum parameter length"
scale = "number of decimal places"
dbName = "database name"
null = "Yes" or "No"
list = "Yes" or "No"
separator = "separator character">
AND/OR ...additional criteria of the WHERE clause...
</cfquery>
cfregistry
<cfregistry action = "getAll"
branch = "branch"
type = "data type"
name = "query name"
sort = "criteria">
<cfregistry action = "get"
branch = "branch"
entry = "key or value"
variable = "variable"
type = "data type">
<cfregistry action = "set"
branch = "branch"
entry = "key or value"
type = "value type"
value = "data">
<cfregistry action = "delete"
branch = "branch"
entry = "keyorvalue">