Ok so I am sitting here beating my head against the desk trying to wrap my mind
around the complexities of what I am trying to accomplish here.
Ok to the point. I have been tasked with creating a merge letter application.
The whole point of this application is to allow users to create dynamic
letters, emails, and documents. However, these documents are going to be output
in html format and not saved to a word doc or RTF file.
In my database, it is a massive relational situation. To keep this simple, I
will explain the basic test document I need to create.
In my example text below, I have several merge fields that I need to populate
from several databases.
Starting off everything with the prefix USER is comes of course from my users
table.
My user table relates to a transaction parties table we will call parties,
which in turn relates to the transaction info table we will call info. Now the
relation between the parties table and the info table is a many to one
relation. Meaning that there are several parties stored per one transaction.
These parties are categorized by types. In-house Agent(This is USER), Client,
Outside Agent, etc.. There can be more then on In-house Agent related to the
transaction.
So I guess basically my question is, how would you build the queries for this.
Right now I have the idea of doing a top down approach. Where a user selects
the transaction, selects the party they want to create the letter for, and so
on. But I am not sure if my logic is exactly sound. Anyone have any ideas on
the best approach to this situation would be.
EXAMPLE LETTER:
Dear {{USERFIRSTNAME}} {{USERLASTNAME}},
It has come to our attention that you dog is currently residing at
{{USERADDRESS}}. Please remove this dog or we will be forced to cut off your
{{USEREMAIL}} address until the dog has been removed.
Please also note that the transaction {{LISTFILENUM}}, has been placed on
probation.
Thank you,
Phoenix Dog Protection Act stuf.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285903
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
