You may also eliminate this problem by changing the "max pooled statements" value in your DSN to 0. I'm not certain of that, but I know that the pooled statements are a form of SQL syntax caching and that for most applications they're not very effective in improving performance, so unlike disabling the "maintain client connections" feature there's not much to lose. I have some recollection of having the same sort of issues myself (change db structure outside cf, get error from unchanged and still valid select statement in cf) and being able to eliminate them that way.
> This bug usually happens when you change something on the > database > server when you are using a prepared statement > (cfqueryparam). The > workarounds I can recommend are > 1. Disable "maintain client connections" in the cf admin - > less desirable > 2. Change the query ever so slightly. I usually add an > extra where > clause : "AND 1=1" which has no performance penalty but > makes the > prepared statement recompile > On 4/14/06, Rick Root <[EMAIL PROTECTED]> wrote: >> what the heck is this? >> >> 19 >= 19 >> >> >> The error occurred in >> E:\Inetpub\wwwroot\tools\email_responses\respond.cfm: >> line 20 >> >> 18 : A.*, B.name as PRMLNAME >> 19 : FROM dbo.results A left join dbo.results2 b on >> a.fromAddress=b.email >> 20 : where id=<cfqueryparam cfsqltype="cf_sql_integer" >> value="#id#"> >> 21 : </CFQUERY> >> 22 : <cfoutput query="data"> >> >> >> It's worth noting that there are 18 columns in the table. >> I dropped >> another column and ran the query again and I got "18 >= >> 18" (now there >> are only 17 columns) >> >> here's the full query: >> >> SELECT >> A.*, B.name as PRMLNAME >> FROM dbo.results A left join dbo.results2 b on >> a.fromAddress=b.email >> where id=<cfqueryparam cfsqltype="cf_sql_integer" >> value="#id#"> >> >> Rick >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237772 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
