Follow-up: When I run the same query below in a query editor, the correct data, 1, 2, 4, 6 is returned.
What wouldn't CF 8 return the same data with the same query? Rick > -----Original Message----- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Sunday, October 14, 2007 1:40 AM > To: CF-Talk > Subject: Why would this query not return the correct data? > > Hi, all. > > Here's the query: > > <cfquery name="get_days" datasource="#dsn#"> > > select distinct event_days from weekly schedule order by > event_day > > </cfquery> > > The data that should be returned if the query is looped is > > 1, 1, 1, 1, 2, 4, 6 > > However, when I run. > > <cfloop query="get_days"> > > <cfoutput>#event_days#</cfoutput> > > </cfloop> > > .. all I get is 1, 1, 1, 1.four ones, and that's it. > > What could I be doing wrong? I knew transitioning from CF 4.5 to CF 8 > would present some issues, but gee whiz. > > Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4