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?
>
> 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/
