[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Printing Labels

Posted on 2007-11-23
2
Medium Priority
?
210 Views
Last Modified: 2013-12-24
I have a simple query for address label.  

select fname, lname, addr, city, st, zip
from demo

I want to print three addresses per row so that I can save trees.


Jone Doe                                 Sue Doe                          Jim Doe
1234 ABC Street                     1233 DEF Street              1233 GHI Street
Good City, PA 21043               Fun City, PA 21042          Great City, PA 21041      
 
Harry Doe                                Liz Doe                            Tim Doe
1234 ABC Street                     1233 DEF Street              1233 GHI Street
Good City, PA 21043               Fun City, PA 21042          Great City, PA 21041  

bla.....

How do you format this?

thx      
0
Comment
Question by:ethanjohnsons
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 52

Accepted Solution

by:
_agx_ earned 2000 total points
ID: 20340674
One way is using MOD and the #queryName.CurrentRow# variable to start a new row every 3 columns.


<table width="600">
<tr><cfoutput query="yourQuery">
	<td>#fName#	#lName#<br>
		#addr#<br>
		#city#, #state# #zip#
	</td>
	<cfif currentRow MOD 3 EQ 0></tr><tr></cfif>
	</cfoutput>
</tr>
</table>

Open in new window

0
 

Author Comment

by:ethanjohnsons
ID: 20341427
it works great!

thx much
0

Featured Post

Understanding Web Applications

Without even knowing it, most of us are using web applications on a daily basis. Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We often confuse these web applications tools for websites.  So, what is the difference?

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question