Posted By

dreamstarter on 07/15/14

Tagged

query

Versions (?)

Last Edited at 07/15/14 11:01pm

Statistics

Viewed 1068 times

Favorited by 1 user(s)

Related snippets

Query output into multiple columns

/ Published in: ColdFusion

coldfusion snippet to output a query recordset into multiple columns

Highlighted TextExpand

<cfset NumCols = 2> 
			<cfset tableBGColor = "99AF26">             
			<cfset tablealign = "left">                     
			<cfset trBGColor = "D6E0A1">                 
			<cfset tdBGColor = "D6E0A1">                 
			<cfset tdHighlightColor = "D6E0A1">     
			<cfset tdEmptyCell = "D6E0A1">             
			<cfset table_cellpadding = 4>                 
			<cfset table_cellspacing = 1>                 
			<cfset table_width = 455>                     
			<cfset table_width_type = "">                 
			<cfset query = "getSponsors">                 
			<cfset ColWidth = Fix(100/NumCols)> 
			<cfoutput>
				<table border="0" cellpadding="#table_cellpadding#" cellspacing="#table_cellspacing#" width="#table_width##table_width_type#" bgcolor="#tableBGColor#" align="#tablealign#">
					<tr valign="top" bgcolor="#trBGColor#">
						<cfloop query="#query#">
							<td align="center" width="#ColWidth#%" bgcolor="#tdBGColor#"> 
								 
								    <a href="?sid=#spn_id#" title="Click here to view more information about this sponsor.">#spn_name#</a><br> 
								
							</td> 
							<cfif (Evaluate(query&".CurrentRow") MOD NumCols) IS 0 AND (Evaluate(query&".CurrentRow") NEQ Evaluate(query&".RecordCount"))>
								</tr>
								<tr valign="top" bgcolor="#trBGColor#">
							</cfif>
						</cfloop>
						<cfif Evaluate(query&".RecordCount") MOD NumCols GT 0>
							<cfset Variables.NumMissingCells = NumCols - (Evaluate(query&".RecordCount") MOD NumCols)>
								<cfloop from="1" to="#Variables.NumMissingCells#" index="iCell"> 
									 
									<td bgcolor="#tdEmptyCell#">&nbsp;</td> 
									 
								</cfloop>
						</cfif>
					</tr>
				</table>
				<br>
			</cfoutput>

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.