@ Azadi: The cfdump reports no query caching. Even after I manually changed the data in the database to exclude the integer 1, I still get all 1's ! What datatype did you assign to event_day? If it was tinyint, did you give it a length of 1?
@ Matthew: I changed two things to make sure I wasn't accessing the wrong database or cfm page. I change the text to red and that worked. I also changed the integers for event_day I the database and they editor query returns the new and correct information. CFDump reports no query caching. @ Aaron: I haven't checked the rest of the site for errors explicitly, but I haven't noticed any problems yet. I'll expand the error search soon if this isn't resolved. @ Aaron: Yes, the cfdump shows consistent data. I get same wrong result whether I cfoutput the query or loop the query. @ Andrew: Your theory could be correct about the bit/Boolean datatype. I had assigned a tinyint datatype with a length of 1. Which would fit the definition for a Boolean and also my single digit day of the week number requirements. However, when I changed the datatype to integer and allowed it to have its full length of 11, I got back the correct results from my query, the cfdump, and sql editor's query. So the issue seems to be solved... but the question remains: Why did my datatype and length no work? Just wanted to say THANKS! to everyone who has helped solve this. Now I really want to understand this behavior so I don't run into unexpected problems in the future. Ideas? Rick > -----Original Message----- > From: Azadi Saryev [mailto:[EMAIL PROTECTED] > Sent: Monday, October 15, 2007 8:56 AM > To: CF-Talk > Subject: Re: Why would this query not return the correct data? > > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:291115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
