here is the query version (I did it with states):
...query for all states...
<cfset columns = 3>
<cfset maxPerCol = ceiling(qStates.recordcount / columns)>
<!--- states list --->
<tr>
<td valign="top">
<table cellpadding="0" cellspacing="2" border="0"
width="100%">
<cfloop query="qStates">
<tr>
<td align="right" class="fieldDesc"
nowrap>#stateName# :</td>
<td>
<input type="text" size="5"
name="newTaxList" maxlength="7" value="#numberFormat(taxRate,"0.00000")#">
<input type="hidden"
name="oldTaxList" value="0#taxRate#">
<input type="hidden"
name="stateIDList" value="#stateID#">
</td>
</tr>
<cfif NOT currentRow MOD maxPerCol>
</table>
</td>
<td valign="top">
<table cellpadding="0"
cellspacing="2" border="0" width="100%">
</cfif>
</cfloop>
</table>
</td>
</tr>
The list version would be similar:
<cfset columns = 3>
<cfset maxPerCol = ceiling(listlen(PairSizeList) / columns)>
.....
+-----------------------------------------------+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 2:07 PM
To: CF-Talk
Subject: Vertical Display...
Last week there was code to display a query's content's 'vertically'. Say I
have the folllowing list:
<cfset PairSizeList =
"8,8.5,9,10,11,12,13,14,15,16,17,18,19,20,22,24,26,28,30,32,34,36,38,40,42,4
4,46,48">
How would I display that list in a table 'vertically' with 4 columns???
TIA-Ch�
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
