*sigh* Well Charlie, when you pushed for time and you reply to something you can't always think of the top of your head. In this case I was trying to picture the settings in the administrator.
Now in my defence, until Duncan came out and said it. It was still not very clear on how he was doing the query, and I was just being as specific as possible for him to look at possible solutions to the problem. However when it came to the actual fix for the problem, oh well I got confused in writing my reply :-( Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: Tuesday, 6 March 2007 1:07 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam Sigh, and I mean, *BIG sigh*. :-) Andrew, what about this set of comments argues in favor of a connection between CFQUERYPARAM and the "cached queries" feature, which you referred to in your earlier note? Are you referring to the "2. Change [Max Pooled Statements] in Datasource Advanced Settings to zero."? That's not about the "cached queries" feature nor its setting, which you referred to twice on Sunday. What that's referring to is, as it says, a setting in the Datasource connection. That specific driver setting is a feature for SQL Server regarding pooling of prepared statements, or what a CFQUERYPARAM causes to be created (among other things). So, as I've been trying to say from the very beginning of this thread, we need to keep the discussion of cached queries (storing the results in memory for later reuse) very separate from the discussion of prepared statements (as affected by CFQUERYPARAM, and any pooling of them in CF via this "max pooled statements" or their caching in the database. That's the only reason I've pressed for clarity over and over. It's all the subject of frequent misunderstanding, as this thread has shown. We just need to all get on the same page. It happens all the time in such lists. Hope this has been helpful. As I said before, I certainly don't press to be antagonistic or arrogant. I've admitted learning something already today here (and I blogged about it, mentioning the list as well). /Charlie http://www.carehart.org/blog/ -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Monday, March 05, 2007 6:15 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam Charlie, The link is http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-b20.htm The quote on the page is : I checked with one of our technical people and this is what he said: ***** Most database (including SQLServer) presume that the database structure does not change between re-uses of parameterized queries. Here are three possible solutions. Try #1 first - it may be enough to fix the problem. With #2 and #3 efficiency is reduced because the SQL statement will be compiled more often. 1. Avoid using wildcard SELECT * expressions. The expansion of the "*" is the part of the SQL statement most likely to change when the schema is altered, making the compiled SQL statement become invalid. If the specific fields are listed (and presuming they are still valid fields after the schema change) the compiled statement might still be useable. 2. Change [Max Pooled Statements] in Datasource Advanced Settings to zero. 3. Use inline arguments instead of <cfqueryparam> to cause the SQL statement be re-compiled by SQLServer for every request. ***** Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---