So.. if the record count is 0 dont display any data ? just use.
<cfif queryName.recordCount eq 0> table to display if the record count is 0 <cfelse> table to display with the data </cfif> On 10/17/06, Robert Makowski <[EMAIL PROTECTED]> wrote: > I am building a page, that i need some conditional processing done on. > Basically, if the user chooses something from a selection list, and if there > is data in other table, then at data is shown on the screen, but if there is > no data for that particluar thing in the table, the html table on the page > still get drawn, but without any data. So what i have been trying to do is > when the user selects something and the associated table doesn't contain any > data for the choice, when i want to redirect the users back to the start page. > > So this is what i did: I created two queries running on the same input. One > is the query for the selection of the data, and the second is the count for > the returned rows. > > So i nested the cfoutput statement in conjunction with cfif and cfelse, and i > found out that you can't do that, for the simple reason that i dont' want the > table to be made if there is no data to show. > > I tried to use only the count query to access the table rows, but that didnt' > work. So now i'm stuck and asking for help. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2141 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
