Please disregard my last email. I was confusing cfoutput and cfif Thanks for the help(again)!
-----Original Message----- From: Robert Makowski [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 3:08 PM To: CF-Newbie Subject: RE: multiple cfquery commands on the same page I see that, but I am still going to run into a problem showing the table headers before cfoutput <table border="1" align="center"> //I DON'T WANT THE CFOUTPUT BEFORE THIS LINE, BECAUSE I DON'T WANT THE COLUMN LABELS TO BE REPEATED EVERYTIME. <tr> <td></td>//THESE THREE LINES ARE WHERE I'M RUNNING INTO PROBLEMS. <td align="center">Status</td> <td align="center">Names</td> <td align="center">Addresses</td> </tr> <cfform name="owner_data" method="post" action="rentalworksheet.cfm">The are the owners at <cfoutput>#hoa#</cfoutput> are: <cfoutput query="owners"> //OUTPUT FOR A TABLE FILL <tr> <td><input type="radio" name="owners" value='#OWNERS.OWNERID#' checked/></td> <td> <cfif #rentalcanceled#>The owner has canceled our program <cfelseif #occupiedavailable#>Unit is <strong>occupied</strong> and <strong>available</strong> <cfelseif #vacentavailable#>Unit is <strong>vacent</strong> and <strong>available</strong> <cfelse>There is currently no status for this unit </cfif> </td> <td>#OWNERS.FIRSTNAME# #OWNERS.LASTNAME#</td> <td>#OWNERS.STREET# #OWNERS.CTY#, #OWNERS.STATE# #OWNERS.ZIP#</td> </tr> </cfoutput> </table> -----Original Message----- From: Vohra, Sandeep Singh [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 2:37 PM To: CF-Newbie Subject: RE: multiple cfquery commands on the same page Instead of sending this query again to check the record count : ---------------------- <cfquery name="ownercount" datasource="#Request.MainDSN#"> SELECT COUNT(*) FROM HOAS INNER JOIN OWNERS ON HOAS.HOAID = OWNERS.PROJECT WHERE HOAS.NAME = <cfqueryparam value="#hoa#" > </cfquery> ---------------------- You can use : ----------------------- <cfif owners.recordcount> ----------------------- Thanks. -Sandy Vohra ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2150 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
