RE: Changing query value
Cedric Did that solve your problem? If not check that there is actually a max value in the? Kola -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 02 July 2003 18:05 To: CF-Talk Subject: Changing query value Steve, Thanks. I had tried [0] and got an error. Never tried [1] though! Doh! Thanks again. Cedric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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
RE: Changing query value
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 FROMGallery /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=subscribeforumid=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
RE: Changing query value
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 FROMGallery /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=subscribeforumid=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