the recordcount is the recordcount of your query.  Do you have that part yet?

Brian Yager
President - North AL Cold Fusion Users Group
http://www.nacfug.com
Sr. Systems Analyst
Sverdrup/CIC
[EMAIL PROTECTED]
(256) 842-8342


-----Original Message-----
From: Phillip Perry [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 2:40 PM
To: CF-Talk
Subject: RE: Showing DB output in html tables.


I tried your code but it says error resolving parameter RecordCount

Phil
-----Original Message-----
From: Everett, Al [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 3:32 PM
To: CF-Talk
Subject: RE: Showing DB output in html tables.


Try this:

<cfscript>
 col1start=1;
 col1max=RecordCount \ 2 + RecordCount MOD 2;
 col2start = col1start + col1max;
 col2max = RecordCount \ 2;
</cfscript>

<table>
<tr>
 <td>
  <table>
   <cfoutput query="queryname" startrow="#col1start#" maxrows="#col1max#">
     ...
   </cfoutput>
  </table>
 </td>
 <td>
  <table>
   <cfoutput query="queryname" startrow="#col2start#" maxrows="#col2max#">
     ...
   </cfoutput>
  </table>
 </td> 
</tr>
</table>

> -----Original Message-----
> From: Phillip Perry [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 25, 2002 1:48 PM
> To: CF-Talk
> Subject: Showing DB output in html tables.
> 
> 
> Hi,
> 
> I have 5 columns in a access db. Fist name, last name, wins, 
> loses, rating.
> I want to break this list into 2 html table columns.. 
> something like the
> following...
> 
> Name          Wins    Loses   Rating  Name            Wins 
> Loses Ratings
> 
> 


______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to