Thanks, Joe! I now understand what Dave was referring to--the cfif around the cfoutput.
Thank you! > -----Original Message----- > From: Joe Eugene [mailto:[EMAIL PROTECTED]] > Sent: Sunday, November 17, 2002 2:29 PM > To: CF-Talk > Subject: RE: RecordCount Question > > > Your output was not entering the loop, when there > were "0" records.. Below is one way of doing it. > > <cfif qSpecific.recordCount> > <cfoutput query="qSpecific"> > <li class="bullet"> > <a > href="ClientManage/ClientPageView.cfm?clientID=#qUsers.userCli > ent#&projI > D=#projectID#&Type=2" class="NavyCopy">#clientName# - > #projectName#</a> </li> </cfoutput> <cfelse> <li > class="bullet"> <span class="NavyCopy"> You have currently > have no active projects. </span> </li> </cfif> </ul> > > > Joe > > > > -----Original Message----- > > From: Russ [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, November 17, 2002 2:57 PM > > To: CF-Talk > > Subject: RecordCount Question > > > > > > I'm attempting to work-through a recordCount issue and display > > information appropriately. When the user has projects, I'll > > bulletpoint them and list them appropriately. > > > > When the user has no projects, I want to display a message > that simply > > tells them that they have no projects; otherwise, the table > looks kind > > of gangly just hanging out there. > > > > My code is below, and when I run this, I still end up > getting an empty > > table, even though I've set the user to have no projects. > > > > Can anyone help me understand where I've missed the bus? Thanks. > > --Russ > > > > > > > > <ul> > > <cfoutput query="qSpecific"> > > <cfif #qSpecific.RecordCount# GT 0> > > <li class="bullet"><a > > > href="ClientManage/ClientPageView.cfm?clientID=#qUsers.userClient#&pro > > jI > > D=#projectID#&Type=2" class="NavyCopy">#clientName# - > #projectName#</a> > > </li> > > <cfelse> > > <li class="bullet"><span class="NavyCopy">You have currently have no > > active projects.</span> > > </li> > > </cfif> > > </cfoutput> > > </ul> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
