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 -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: Tuesday, 6 March 2007 9:03 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam Well, I know I just wrote my last note so you can't have seen it yet, but I'll answer more directly this later question of yours, Andrew: there is no connection between CFQUERYPARAM and the "cached queries" feature. Are you saying you have some MM resource that suggests otherwise? That would be very interesting to see, so I hope you can find and share it. (Hey, I learned about the NULL attribute only today, as I mentioned earlier, so I'm always open to learning new info.) /Charlie http://www.carehart.org/blog/ -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Sunday, March 04, 2007 7:03 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam Acually not sure, but the problem Duncan was having was suggested my Macromedia so that shows you it is a known problem and how long it has been around for, suggests for the cfqueryparam slect * from problem to set the cached queries queue to zero. But it might effect that attribute as well.... Charlie might be able to fill us in more maybe. 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 -~----------~----~----~----~------~----~------~--~---
