CFLOOP De Loop....

smokin_joe · smokin_joe

I am trying to print out the contents of a session variable, into a 3 column
table (for mailing labels) using cf loop (You may not be able to see it in this
post, but the records (1) (2) (3), etc actually line up in columns and rows) .

The code listing works fine, except, when you look at the output page. (the
listing below is only a snippet, there are actually 10 rows of output, that I
have not included) While each of the records print in the the correct
row/column, I also get the next record in rows, in this example (8) for all of
the rows that have not already printed. If I add record 8 to the list than the
remaining linse display (9), etc.

For some reason the loop "looks" ahead, for lack of a better technical term;
or I am not looping or placing the query in the right place?

Can someone assist?

THANKS

There is (are) 7 mailing labels in the mailing label basket. GREAT... You
Still Have More Room

(1) Jarret Brown (2) Frank Barone
(3) Matt Damon
S 1313 13 Ave Apt 56 W 2 110 Avenue Apt 55
N 323 111 Avenue Apt 443
NY NY,NY 12345 NY NY,NY 11111
Brooklyn NY,NY 12345

(4) Emeril Lapone (5) Kathy Garson
(6) Garth Brooks
S 5345 113 Avenue Apt 4 E 6634 114 Avenue Apt 3 W
2343 115 Avenue Apt 5
Brooklyn NY,NY 12345 Staten Island NY,NY 11111 Queens
NY,NY 22222

(7) Glen Frye
N 423 116 Road Apt 1
Bronx NY,NY 12345

(8)

(8)

(8)

(8)

<table>

<tr valign="top">
<cfif session.basket.CurrentRow EQ '1'><cfloop query="session.basket"
startrow="1" endrow="3"><cfoutput>
<td width=12 style='width:9.0pt;padding:0in .25pt 0in
..75pt;height:1.0in'>
</td>

<td width=252 style='width:189.0pt;padding:0in .25pt 0in
..75pt;height:1.0in'>

(#session.basket.CurrentRow#) #session.basket.SHFirstName#
#session.basket.SHLastName# 
#session.basket.Prefix#
#session.basket.BuildingNo# #session.basket.S treetName#   #s
ession.basket.Suffix# #session.basket.Apt# 
#session.basket.SHCity#
#session.basket.SHState#   #session .basket.SHPostalCode#</fon
t>
</cfoutput></cfloop></cfif></td></tr>

<tr valign="top">
<cfloop query="session.basket" startrow="4" endrow="6"><cfoutput>
<td width=12 style='width:9.0pt;padding:0in .25pt 0in
..75pt;height:1.0in'>
</td>

<td width=252 style='width:189.0pt;padding:0in .25pt 0in
..75pt;height:1.0in'>

(#session.basket.CurrentRow#) #session.basket.SHFirstName#
#session.basket.SHLastName# 
#session.basket.Prefix#
#session.basket.BuildingNo# #session.basket.S treetName#   #s
ession.basket.Suffix# #session.basket.Apt# 
#session.basket.SHCity#
#session.basket.SHState#   #session .basket.SHPostalCode#</fon
t>
</cfoutput></cfloop></td></tr>

<tr valign="top">
<cfloop query="session.basket" startrow="7" endrow="9"><cfoutput>
<td width=12 style='width:9.0pt;padding:0in .25pt 0in
..75pt;height:1.0in'>
</td>

<td width=252 style='width:189.0pt;padding:0in .25pt 0in
..75pt;height:1.0in'>

(#session.basket.CurrentRow#) #session.basket.SHFirstName#
#session.basket.SHLastName# 
#session.basket.Prefix#
#session.basket.BuildingNo# #session.basket.S treetName#   #s
ession.basket.Suffix# #session.basket.Apt# 
#session.basket.SHCity#
#session.basket.SHState#   #session .basket.SHPostalCode#</fon
t>
</cfoutput></cfloop></td></tr>

CFLOOP De Loop....

Thread Tools

Display

CFLOOP De Loop....

Similar Questions and Discussions

ASP Do While Loop to CFLOOP

concat cfloop index to cfoutput variable inside loop?

Film loop rollovers working with tell sprite, but only if Loop is checked

Urgent: Repeat loop and Film loop clash!

Help with loop inside loop and mysql queries

Posting Permissions