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.
On 10/15/07, Azadi Saryev <[EMAIL PROTECTED]> wrote: > > 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/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4