Two D Query Grid

	Print
	Email

Submitted on: 12/4/2002 12:59:53 PM
By: Richard Durant
Level: Advanced
User Rating: Unrated
Compatibility:Cold Fusion 4.5

Users have accessed this code 1730 times.

(About the author)

The code segment outputs a query to a n*m table

code:
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!

Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.


    //**************************************
    //     
    // Name: Two D Query Grid
    // Description:The code segment outputs 
    //     a query to a n*m table
    // By: Richard Durant
    //
    // Inputs:Just the query
    //
    // Assumes:The query is called recipient
    //     s.
    The example outputs a 4*4 table
    the table automatically resizes its rows to accomodate the results.
    In the example i put checkboxes in the table cells, this can be changed to put any other element or just the query results
    //
    //This code is copyrighted and has    // limited warranties.Please see http://
    //     www.Planet-Source-Code.com/vb/scripts/Sh
    //     owCode.asp?txtCodeId=64&lngWId;=9    //for details.    //**************************************
    //     
    
    <table width="100%" cellspacing="1" cellpadding="1" border="0" id="common_font" >
    				<cfoutput query="recipients">
    				<cfif #recipients.currentrow# mod 4 eq 1>
    				<tr><td>
    					<input type="checkbox" name="chkrecipient" value="#emailaddress#"><font size="-2">#name#</font></td>
    				<cfelse>
    					<td>
    					<input type="checkbox" name="chkrecipient" value="#emailaddress#"><font size="-2">#name#</font></td>
    			</cfif>
    				<cfif #recipients.currentrow# mod 4 eq 0>
    					</tr>
    				</cfif> 
    				</cfoutput>
    				</table>

Other 1 submission(s) by this author

Report Bad Submission

Your Vote!

Other User Comments

There are no comments on this submission.

Add Your Feedback!

Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.

NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.

For feedback not related to this particular code, please click here.