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.userClient#&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#&projI > 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 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
