[thelist] One for the GURU's asp loop

Brian Delaney brian.delaney at mccmh.net
Fri Apr 29 10:02:35 CDT 2005


I have a recordset that contains company name,addr,addr1,city,state,zip

I am trying to format the asp output so labels can be printed. I am 
close using a style sheet and some margin tweaking.

My question is  as follows:

I need to write the records 3 companies per row:

company1       company2       company3
addr                addr                addr
addr1              addr1              addr1
city,state zip     city,state zip    city,state zip

I originally used 3 arrays  to read the first, second and third company 
with movenext in between, then write out  the row using the arrays,
loop, redim my arrays and get the next three - repeat.

This produces duplicate companies.

Looking for suggestions on the best way to handle this. Maybe use the 
cursor command to get the first three?

I use ASP on MS with sql 2000 backside.

Thanks

*
*
*
This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or priveleged information.  Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited.  If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.


More information about the thelist mailing list