But it is, And I did post the answer to you in one of my previous posts to this post.
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 Duncan Sent: Monday, 5 March 2007 8:47 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: @#$!! queryparam We are not caching any templates. In CFAdmin there are no cached templates, trusted cache or saving of class files. We are not using a framework, its as simple as putting a cfquery into a .cfm page and running it directly in the browser. It is only on queries with select * in them. On queries that are specifically tailored to pull only certain columns (i.e. no star *) it does not happen. We are running 7,0,1,116466 CFMX 7 Standard edition, using SQL 2000, and the standard Microsoft SQL Server Driver. We havent updated CF to 7.0.2 because none of the items in the issues list for the updater or patches have deemed it to be necessary in our case. Now hopefully you can see why I am asking about this - its a simple simple thing we are doing, but the answer doesnt look to be simple. Charlie, I will introduce myself at WebDU. On 3/3/07, Charlie Arehart <[EMAIL PROTECTED]> wrote: > > Again, this is going down the template cache and query cache routes, in > trying to solve Duncan's problem with his CFQUERYPARAM error. Please do tell > us, Duncan, if it's just the SELECT * or if indeed the problem remains even > after that. > > But the points Andrew makes before are indeed often valuable ones when you > have curious problems of errors "sticking around" when it's not obvious why > they should. Good call, too, on implying the potential difference among DB > drivers. That's another way to try to resolve curious problems, sometimes. > > /Charlie > http://www.carehart.org/blog/ > > -----Original Message----- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of Andrew Scott > Sent: Thursday, March 01, 2007 10:08 PM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Re: @#$!! queryparam > > > The suggestions I had mentioned, I didn't think of Trusted Cache but I never > have that ticked for development but that might cause it and the other is > Save Class Files but you will also need to delete the class files that are > generated there as well. > > The other option is Maximum number of cache queries, but I think and am not > 100% sure that this is for the actual attribute cache for query tags! > > Now if you have done the above, we need more info about your environment > that might cause this. Is the query in a cfc, that might be used in a scope > like session or application or using a framework like MG:U, fusebox, Mach-II > that might implement its own form of caching of queries and or components. > > Other than these, I cannot see any other reason without seeing the code that > might be causing this. > > And are you using standard, coldfusion database connection and not a JDBC > alternative? > > HTH in some way. > > Andrew Scott > > > > > -- Duncan I Loxton [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---