are you trying to display
<tr>
<td></td>
<td align="center">Status</td>
<td align="center">Names</td>
<td align="center">Addresses</td>
</tr>
If there is data to display ? and hide all if there is no data ?
On 10/17/06, Robert Makowski <[EMAIL PROTECTED]> wrote:
> 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:2149
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
