I had it resolved. Thanks for th eheads up Brian.

-----Original Message-----
From: Yager, Brian T Contractor/Sverdrup
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 3:44 PM
To: CF-Talk
Subject: RE: Showing DB output in html tables.


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
>
>



______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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