Ok..this seemed easy at first..now I'm a bit ticked that I can't
figure this out. I'm sure you CF mavens out there have come across
this already; I'd appreciate your insight. :)
I would like to output my query into a 2 column table; reading left to
right.
Example:
1 2
3 4
5 6
What I'm getting with my code is:
1 2
2 3
3 4
Here's my code:
<cfquery name="blah" datasource="employees">
select * from employees where fname like 'John%' order by fname,
lname
</cfquery>
<cfoutput>
<table border="1">
<cfset counter = 0>
<cfloop query="blah">
<tr>
<td>#blah.fname# #blah.lname#</td>
<td>#blah.currentRow#</td>
<td>#blah.fname[currentRow+1]# #blah.lname[currentRow+1]#</td>
<td>#blah.currentRow+1#</td>
</tr>
<cfset counter = counter+1>
<cfset blah.currentrow = blah.currentRow+counter>
</cfloop>
</table>
</cfoutput>
Anyone know how I can work this out to the output that I'd want? How
do I also not show the the 2nd <td> if it's not populated (an odd #
recordset)>
Thanks in advance
Chris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:234872
Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
