I know this does not solve the actual problem but if all you need to do is convert 1-7 to the day of the week you could just make a query result using the QueryNew() function and avoid querying the database altogether. Are you 100% sure this is the only query in the site returning incorrect data?
On 10/15/07, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > numbers 1-7 to convert to a day of the week. Which worked fine in MySQL > 4.1 > and CF 4.5. > > -- Aaron Rouse http://www.happyhacker.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4