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:2140 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
