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:237760 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
