Not sure if I understood all but did you try using 'queryname.RecordCount' instead.
Better if you could post some code as well. Thanks. -Sandy Vohra -----Original Message----- From: Robert Makowski [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 1:53 PM To: CF-Newbie Subject: multiple cfquery commands on the same page 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:2142 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
