CODEWITHSUNDEEP
coldfusioncoldfusion-11
Scott Jibben
Scott Jibben

Reputation: 2287

What are the options for queryOptions in the queryExecute function?

The online documentation for the new ColdFusion 11 function queryExecute is here:

https://wikidocs.adobe.com/wiki/display/coldfusionen/QueryExecute

    QueryExecute(sql_str, queryParams, queryOptions);

Does anyone have documention for all of the options for "queryOptions" for this function?

The only options listed are in the examples in the documentation:

    result
    datasource
    fetchclientinfo
    cachename

I'm only sure of "datasource" and what it is for. There must be others like "cachedwithin", "blockFactor", and the other options that can be used with <cfquery>.

Upvotes: 4

Views: 916

Answers (1)

Raymond Camden
Raymond Camden

Reputation: 10857

It is the same as cfquery:

blockFactor = "block size"
cachedAfter = "date" 
cacheID = "ID"
cacheRegion = "region"
cachedWithin = "timespan"
dataSource = "data source name"
dbtype = "query"
debug = "yes|no"
fetchClientInfo = "yes|no"
maxRows = "number"
ormoptions = #orm options structure# 
password = "password"
result = "result name"
timeout = "seconds"
username = "user name"

If you want to know what these do, check the docs for cfquery. I assume you were asking for the list, not what each of these mean since they are already documented.

Upvotes: 7

Related Questions