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