LiveDocs Comments - coldfusion - 7 - htmldocs - 00001734.htm

coldfusion/7/htmldocs/00001734.htm

Jens — 2007-03-30T11:17:13

for MS SQL Admin API setup note the following issues:

* setStringParametersAsUnicode = true
is wrong, this should be
sendStringParametersAsUnicode = true

* selectmethod = "direct" is undocumented, but if you don't set this then the Select Method will default to "cursor" and if it is a MS SQL 2005 connection then the DSN will fail with the following SQL error "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): Data type 0x38 is unknown"

coldfusion/7/htmldocs/00001734.htm

Xtreme-Host — 2006-05-11T09:03:37

In reviewing datasource.cfc

"timeout: numeric, optional, timeout - The number of minutes that ColdFusion maintains an unused connection before destroying it.
interval: numeric, optional, interval - The time (in minutes) that the server waits between cycles to check for expired data source connections to close. "

However, the values must be specified in seconds and not minutes when passing this param.

coldfusion/7/htmldocs/00001734.htm

jrunrandy — 2005-07-19T08:18:26

You are correct. The ClearTrustedCache() method in the adminapi is the same as the Clear Template Cache Now button in the CFMX Administrator.

I have entered doc bug 60642 to track this issue.

coldfusion/7/htmldocs/00001734.htm

LearningExpressLLC — 2005-07-18T15:31:21

According to the doc file for cfide.adminapi.runtime, clearTrustedCache() "Turns off the TrustedCache property to reduce file system overhead."

Is this correct documentation? Or is it instead the equivalent of pressing the "Clear Template Cache Now" button in ColdFusion Administrator? It seems to me that the programmatic way of turning off the Trusted Cache setting is to use setCacheProperty ("TrustedCache", true).

Anyone experienced with this?

(I've also posted this in the forums: http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=143&threadid=1026103&forumid=1)