This is a multi-part message in MIME format.
------=_NextPart_000_0028_01C01534.63EE05C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
<TABLE WIDTH="85%">
<TR>
<TD colspan="3">List of last names</td>
</tr>
<cfset tabCount=1>
<CFLOOP QUERY="myquery">
<CFIF tabCount EQ 3>
<TD><CFOUTPUT>#myQuery.CurrentRow#
#myQuery.LastName#</cfoutput></TD></TR>
<CFELSEIF tabCount EQ 2>
<TD><cfoutput>#myQuery.CurrentRow# #myQuery.LastName#</cfoutput></TD>
<CFELSE>
<TR><TD><cfoutput>#myQuery.CurrentRow#
#myQuery.LastName#</cfoutput></TD>
</CFIF>
<CFIF tabCount LT 3>
<CFSET tabCount = tabCount+1>
<CFELSE>
<CFSET tabCount=1>
</cfif>
</CFLOOP>
</tr>
</table>
This worked for me!
Good Luck
Larry Juncker
Senior Cold Fusion Programmer
HeartlandInternet
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Michael Kear
Sent: Friday, September 01, 2000 1:12 AM
To: [EMAIL PROTECTED]
Subject: How to display across a row instead of down?
I want to display the results of my query in 3 columns instead of one. I
know the method is something to do with mod3, but I'm dashed if i can
figure it out.
What I want to get is:
[record1] [record2] [record3]
[record4] [record5] [record6]
etc
Can anyone help me please with how to code it?
Cheers,
Mike Kear
AFP Web Development
Windsor, NSW, Australia
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------=_NextPart_000_0028_01C01534.63EE05C0
Content-Type: text/x-vcard;
name="Larry Juncker Sr.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="Larry Juncker Sr.vcf"
BEGIN:VCARD
VERSION:2.1
N:Juncker;Larry
FN:Larry Juncker Sr
ADR;HOME:;;;;;;United States
LABEL;HOME:United States
X-WAB-GENDER:2
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20000406T115445Z
END:VCARD
------=_NextPart_000_0028_01C01534.63EE05C0--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
