Try: <cfset getMaxOrder.sortOrder[1] = 0>
Even though you are only returning 1 row you still need to tell CF that it is row 1. Steve -----Original Message----- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 1:06 PM To: CF-Talk Subject: Changing query value 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4