I will check into the genericness of the fields. Could be that is causing me problems though it seems unlikely.
I did what you suggested and it does work, but what a kludge! What causes this to happen? Any idea? In this project it really stood out so it was easy to notice but I worry about others where maybe the results are just numbers and it would be really hard to even notice it is happening until it got noticed in a really bad way. --aimee At 09:48 PM 4/30/2002 -0400, you wrote: >If possible, try changing the name of the more "generic" fields in the >database. I would also suggest scoping the variables to the query name >within the output. > >One way to work around this problem would be to use logic similar to the >code you're already using for the release date display. Set a local >variable at the end of the loop with the contents of news.notes and compare >that variable against the current value during display. If they're equal, >don't display it, otherwise output. While it's a clunky workaround and >should solve the problem, I would suggest eventually finding the source and >rewriting it properly. > >-Justin Scott, Lead Developer > Sceiron Internet Services, Inc. > http://www.sceiron.com > > >----- Original Message ----- >From: "Aimee Abbott" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Tuesday, April 30, 2002 10:14 PM >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> > > > > > > > > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
