need help with display table in cfoutput query

Please try this one

<cfscript>

    row=1;

</cfscript>

<table>

    <cfoutput query="myquery" >

            <cfif row mod 2 eq 1>

                <tr>

                <td>#row#</td><td>#myquery.email#</td><td>#myquery.phone#</td>

            </cfif>

            <cfif row mod 2 eq 0>

                <td>#row#</td><td>#myquery.email#</td><td>#myquery.phone#</td>

                </tr>

            </cfif>

            <cfset row=row+1>

    </cfoutput>

</table>

Sometimes its tricky to get the kind of output you want when you are populating a table with the results of a query, during web application development.

After every two records you want to close the row with </TR> tag, and create a new row in the table using the <TR> tag, which stands for TABLE ROW. Using the MOD function is probably the best way to do this. If the currentrow is divided by 2 with no remainder, then you have to create a new row of data. the equivalent in ColdFusion is <cfif (CurrentRow MOD 2) eq 0>

Here is an example of the code you would need:

<table>

<tr>

<cfoutput query="myquery">

<td>

#myquery.email#<br/>

#myquery.phone#<br/>

</td>

<!--- if we have outputed two cells of data, close the row and start a new row unless we are at the end of the data --->

<cfif ((currentrow mod 2) eq 0) or (CurrentRow eq RecordCount)>

     </tr>

     <cfif CurrentRow lt RecordCount> <!--- if we are not at the end of the data, start a new row in the table for data --->

        <tr>

     </cfif>

</cfif>

</cfoutput>

</table>

You have to visualize how the data will be outputed. Hope this helps.

Michael G. Workman

mworkman@usbid.com

http://www.usbid.com

http://ic.locate-ic.com

<cfquery name="myquery" datasource="mydsn">

select email,phone from mytable

</cfquery>

<table>

<tr>

<cfoutput query="myquery">

<td>

#myquery.email#<br/>

#myquery.phone#<br/>

</td>

<cfif currentrow mod 2 eq 0 or currentrow eq recordcount>

     </tr>

</cfif>

</cfoutput>

</table>

Do you really want to display the email and phone of 2 different users on the same row? That doesn't make sense to me. Then again, do you mean, by 2 records per row, that you wish to display the email and phone per user per row? If so, then you require something like this

<table>

<cfoutput query="myquery">

<tr>

<td>

#myquery.email#

</td>

<td>

#myquery.phone#

</td>

</tr>

</cfoutput>

</table>

<cfif currentrow mod 2 is 0 and currentrow lt recordcount></tr><tr></cfif>

Your job is figure out where to put it.