I suppose I should Apologize for not letting you know I was a semi-newbie. I didn't know that the query name was supposed to go befor recordcount. I apologize for wasting your time.
-----Original Message----- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 3:47 PM To: CF-Talk Subject: RE: Showing DB output in html tables. Well, duh. It's not complete. You need to put your query name there, e.g., queryName.RecordCount. I thought it was obvious. > -----Original Message----- > From: Phillip Perry [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 3: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
