Solved

how to create a flyer on the fly

Posted on 2003-11-26
2
234 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
ID: 9832036
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
ID: 9834342
thanks for the points, hope you got some ideas on how to implement a web based version
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
tomcat7  URL keeps resolving to https instead of HTTP 4 61
How to solve ssl error handshake failure alert on IE 1 206
IIS Site Configuration Copy 2 77
CFFILE upload help 98 159
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 …
Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

810 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