Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

how to create a flyer on the fly

Posted on 2003-11-26
2
Medium Priority
?
240 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
[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
2 Comments
 
LVL 25

Accepted Solution

by:
James Rodgers earned 150 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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

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 …
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…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

719 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