Considering that your doing a select distinct, the correct output
should be 1, 2, 4, 6 and not 1, 1, 1, 1, 2, 4, 6 as you first stated.
So it looks like you're getting the very first value 4 times. Try to
scope the output and see if that helps:
<cfloop query="get_days">
<cfoutput>#get_days.event_days#</cfoutput>
</cfloop>
Or better yet drop the <cfloop> all together and only use <cfoutput>
<cfoutput query="get_days">#event_days#</cfoutput>
/Max
On 10/14/07, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> 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:291026
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
