Hi, Started to get errors after the upgrade for lines like this in CFQUERY:
ORDER BY <CFIF ISDEFINED("attributes.TEAM_ID")> TEAMORDER, </CFIF> Pos, Result DESC The Error back is: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1 . . 66 : <CFIF ISDEFINED("attributes.TEAM_ID")> 67 : TEAMORDER, 68 : </CFIF> 69 : Pos, 70 : Result DESC Seems that CFQUERY isn't working correctly? ____________________________________ Kev McCabe Senior ETV Developer ETV Development Team Technology Development British Sky Broadcasting Tel: +44 (0)20 7941 5329 Fax: +44 (0)20 7941 5369 Web: <http://www.sky.com <http://www.sky.com> > Wap: <http://mobile.sky.com <http://mobile.sky.com> > ____________________________________ ----------------------------------------------------------------------- Information in this email may be privileged, confidential and is intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you have received it in error, please notify the sender by return e-mail and delete it from your system. You should not reproduce, distribute, store, retransmit, use or disclose its contents to anyone. Please note we reserve the right to monitor all e-mail communication through our internal and external networks. ----------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4