I doubt it would make any difference, if the cfdump has the wrong values
then the problem would be outside of how he is looping over the query and
referencing the values.
>
> now that IS strange... is there some query caching involved???
> i have even reproduced your table and query on my CF8/MySQL5 setup, and
> it returns correct data...
> does your cfdump still return 1,1,1,1 ???
>
> did you try running:
>
> <cfoutput query="get_days">
> #get_days.event_day#<br/>
> </cfoutput>
>
> (no cfloop)
>
> Azadi
>
>
--
Aaron Rouse
http://www.happyhacker.com/