I'm using CF5 and trying to change a value that was pulled from a query. My code looks like this:
<cfquery name="getMaxOrder"> SELECT MAX(sortOrder) AS sortOrder FROM Gallery </cfquery> <cfset getMaxOrder.sortOrder = 0> When I try to set getMaxOrder.sortOrder I get an error that says: Cannot convert to number. Please, check the ColdFusion manual for the allowed conversions between data types Any idea why I'm getting this error? Works like a champ on CFMX, but not on CF5. Any ideas? Cedric ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
