Solved

how to create a flyer on the fly

Posted on 2003-11-26
2
236 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

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

Suggested Solutions

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…
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.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

839 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