did you try <cfset querySetCell(getMaxOrder, "sortOrder", 0, 1) />
The '1' is the row number you want to set. it defaults to the last row in the recordset if omitted. --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Cedric Villat [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 02, 2003 10:06 AM > 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