CFLOOP output Question

2000-12-09 Thread KJis18 


Ok, what I want to do is output a query to two tables side by side.

Now i tried this but it doesn't quite work well.  Any suggestions?

cfquery datasource="data" name="information"
SELECT *
FROM Table
/cfquery

cfset firstrow = #information.RecordCount# / 2
cfset secondrow = (#information.RecordCount# / 2) + 1

cfloop query="information" startrow="1" endrow="#FirstRow#"
output table
/cfloop

cfloop query="information" startrow="#SecondRow#" 
endrow="#information.RecordCount#"
output table
/cfloop

Thanks

Kevin


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cfloop Output Question

2000-12-09 Thread Christopher P. Maher 

Put the two tables inside a one row two cell table.

tabletrtd...output for first table.../td
td..output for second table.../td/tr/table

Chris

---
Christopher P. Maher
mailto:[EMAIL PROTECTED]
Maher Associates, Inc.
Actuarial and Computer Consulting
http://www.maherassociates.com


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Friday, December 08, 2000 7:28 PM
 To: CF-Talk
 Subject: Cfloop Output Question
 
 
 Ok, what I want to do is output a query to two tables side by side.
 
 Now i tried this but it doesn't quite work well.  Any suggestions?
 
 cfquery datasource="data" name="information"
 SELECT *
 FROM Table
 /cfquery
 
 cfset firstrow = #information.RecordCount# / 2
 cfset secondrow = (#information.RecordCount# / 2) + 1
 
 cfloop query="information" startrow="1" endrow="#FirstRow#"
  output table
 /cfloop
 
 cfloop query="information" startrow="#SecondRow#" 
 endrow="#information.RecordCount#"
  output table
 /cfloop
 
 Thanks
 
 Kevin
 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Cfloop Output Question

2000-12-09 Thread KJis18 

Well my question was how can i split up the query so it will output the data 
dynamically.

kev


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Cfloop Output Question

2000-12-08 Thread KJis18 

Ok, what I want to do is output a query to two tables side by side.

Now i tried this but it doesn't quite work well.  Any suggestions?

cfquery datasource="data" name="information"
SELECT *
FROM Table
/cfquery

cfset firstrow = #information.RecordCount# / 2
cfset secondrow = (#information.RecordCount# / 2) + 1

cfloop query="information" startrow="1" endrow="#FirstRow#"
 output table
/cfloop

cfloop query="information" startrow="#SecondRow#" 
endrow="#information.RecordCount#"
 output table
/cfloop

Thanks

Kevin


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists