[thelist] RePost - One for the GURU's asp loop

Brian Delaney brian.delaney at mccmh.net
Mon May 2 08:44:33 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.
>  
>

*
*
*
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