Solved

how to create a flyer on the fly

Posted on 2003-11-26
2
232 Views
Last Modified: 2013-12-24
Hi

I have a database (Oracle backend Access front end) that allows me to create specific flyers according to the criteria entered.  At the moment, I use a product called 4tops with the Access form that puts all of the database information into the template fields and then creates a merged Microsoft word document.  Not all fields are compulsory.

I am now at the point where I need to extend this facility to a web page.  I need some direction as to how to do this on the web.  I have had some experience with Cold Fusion and already have some pages from a different databse on the web using this.

any suggestions
0
Comment
Question by:jainesteer
  • 2
2 Comments
 
LVL 25

Accepted Solution

by:
James Rodgers earned 50 total points
Comment Utility
use the access queries that are used to create the word document content as the basis of developing the necessary oracle queries, do the page layout to output the associated text/images etc you get from the queries into place in the appropriate locations

create the page layout first  if you are going to have 1 query fro each information section, eg:

if you have a four section one page flyer

----------------------------------------------
|Section 1 text      | Section 2 text       |
|Section 1 text      | Section 2 text       |
|Section 1 image   | Section 2 image   |
|Section 1 text      | Section 2 text       |
==========================
|Section 3 text      | Section 4 text       |
|Section 3 text      | Section 4 text       |
|Section 3 image   | Section 4 image   |
|Section 3 text      | Section 4 text       |
----------------------------------------------

if you can get all the info for all sections in one query you can loop through the query and generate the layout dynamically using tables and cfif to end one table an start a second as needed
0
 
LVL 25

Expert Comment

by:James Rodgers
Comment Utility
thanks for the points, hope you got some ideas on how to implement a web based version
0

Featured Post

Network it in WD Red

There's an industry-leading WD Red drive for every compatible NAS system to help fulfill your data storage needs. With drives up to 8TB, WD Red offers a wide array of solutions for customers looking to build the biggest, best-performing NAS storage solution.  

Join & Write a Comment

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
This video discusses moving either the default database or any database to a new volume.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now