> 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?
Try outputting the text to the screen before the query - see what's being sent to the Dbengine... That usually helps ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4