You should be grouping by reldate *IF* reldate is a date and no time.
Then you don't need the
> <!--- check to see if we have already printed the big date
--->
> <cfif #lastDate# not equal #relDate#>
> <tr><td valign=top bgcolor="c6d6bd" colspan="2"><font
>size="+1"><b>#dateFormat(relDate, "mmmm dd,
yyyy")#</b></font></td></tr>
>
> <cfset "lastDate"=#relDate#>
> </cfif>
section. You just need...
<tr><td valign=top bgcolor="c6d6bd" colspan="2"><font
>size="+1"><b>#dateFormat(relDate, "mmmm dd,
yyyy")#</b></font></td></tr>
Regards,
Matthew Walker
/*
Cabbage Tree Creative Ltd
Christchurch - New Zealand
http://www.matthewwalker.net.nz/
http://www.cabbagetree.co.nz/
*/
-----Original Message-----
From: Aimee Abbott [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 1 May 2002 2:15 p.m.
To: CF-Talk
Subject: RE: variable not being cleared in a loop?
No, I can't order by title, I must order by date. This is a list of
news
releases and public notices ordered by date, descending.
However, even if I do order by title the same trouble happens. This is
the
page ordered by date, I did order by title after your message and the
trouble still happens.
http://www.pca.state.mn.us/news/data/index.cfm?NR=1
Scroll down to April 1st, March 29th and March 28th.
It happens.
--aimee
At 05:44 PM 4/30/2002 -0700, you wrote:
>First of all your ORDER BY should probably start with title, since that
is
>what you group by in your output. If you don't you will likely output
the
>same title more than once by accident.
>
>Other than that you should be fine. A query row will NEVER inherit
data
>from another query row.
>
>+-----------------------------------------------+
>Bryan Love
> Macromedia Certified Professional
> Internet Application Developer
> Database Analyst
>Telecommunication Systems
>[EMAIL PROTECTED]
>+-----------------------------------------------+
>
>"...'If there must be trouble, let it be in my day, that my child may
have
>peace'..."
> - Thomas Paine, The American Crisis
>
>
>
>-----Original Message-----
>From: Aimee Abbott [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, April 30, 2002 6:32 PM
>To: CF-Talk
>Subject: variable not being cleared in a loop?
>
>
>I have something odd happening with a variable not being cleared. The
>trouble is with the "notes" field. I query it and get the value from
the
>database. The notes field is almost always filled in, however there
are a
>few times where it is not. If the notes field is blank, it will get
filled
>in by the data from the last note field that was filled in. How (and
why)
>can this be???
>
>Here is my query:
>
><CFQUERY name="news" datasource="newsData">
> select Notices.noticeID, Notices.title, Notices.reldate,
>Notices.expiryDate, Notices.url, Notices.notes, Notices.release,
>DT1.FullsizeIconAssoc, DT1.smallIconAssoc,supportDocs.title as
>supportTitle, supportDocs.url as Surl, noticeType as NT
> from notices, docTypes DT1, supportDocs
> WHERE Notices.relDate <= '#todayis#'
> <cfif #noticeType# not equal 1>
> AND Notices.relDate > '#minus60#'
> </cfif>
> AND ((Notices.expiryDate >= '#todayis#') or
((Notices.expiryDate) Is
>Null))
> AND Notices.docTypeID = DT1.docTypeID
> and Notices.NoticeID = supportDocs.noticeID(+)
> <cfif #noticeType# equal "1" OR #noticeType# equal "2">
> AND noticeType = #noticeType#
> <cfelse>
> AND Notices.whatsNew = 1
> </cfif>
> ORDER BY Notices.reldate DESC, Notices.NoticeID
></CFQUERY>
>
>
>Then I have the output:
>
><cfoutput query="news" group="title">
> <!--- check to see if we have already printed the big date
--->
> <cfif #lastDate# not equal #relDate#>
> <tr><td valign=top bgcolor="c6d6bd" colspan="2"><font
>size="+1"><b>#dateFormat(relDate, "mmmm dd,
yyyy")#</b></font></td></tr>
>
> <cfset "lastDate"=#relDate#>
> </cfif>
> <tr>
> <td valign="top"><img src="#FullsizeIconAssoc#"></td>
> <!--- Turn back on for debugging --->
> <!--- <td>#noticeID#</td><td>#relDate#</td> --->
> <td>
> <cfif #url# equal "http://"; and #release# not equal
"">
> <cfif (isdefined("WN")) and (#NT# equal
2)>News
>Release: </cfif><a
>href="newsRelease.cfm?NR=#NoticeID#&type=#NT#">#title# </a>
> <!--- <br>#release# <br> --->
> <cfelse>
> <a href="#url#">#Title#</a>
> </cfif><font color="White"
>size="-2">NoticeID:#NoticeID#</font><br>
> <cfif #NT# equal "1">
> <font size="-1"><br>Open for public
comment
>through
>#DateFormat(expiryDate, "MMMM DD, YYYY")#</font>
> </cfif>
> <font size="-1">#notes#</font>
> <!--- ^------ HERE IS
WHERE THE
>TROUBLE IS!!!! --->
> <br>
> </td>
> </tr>
>
> <cfif #supportTitle# not equal "">
> <cfoutput>
> <tr><td></td><td><img src="#smallIconAssoc#">
<a
>href="#Surl#">#supportTitle#</a></td></tr>
> </cfoutput>
> </cfif>
> <tr><td> </td></tr>
></cfoutput>
>
>
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
