Dave, I've got to admit that it's a unique solution for your needs. I'm not
sure what issues it raises because I've never seen this solution before, it
is definitely uncharted territory in my neck of the woods.
I guess I might have leaned more to a flat file solution like Phillip
suggested. You could generate these files at night and then never have to
access the DB again in order to display the data for the invoices. A total
database solution is really not a good way to go, especially if your DB is
getting hammered now during the day. Just a thought...
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of David Shuck
> Sent: Friday, March 16, 2001 11:07 AM
> To: [EMAIL PROTECTED]
> Subject: RE: inserting html into a DB field
>
>
> Considering there are going to be 40,000-70,000 bills generated
> each month,
> it sure would create a lot of files. Unless anyone can think of problems
> with storing the html code in a db field for future retrieval, I
> think that
> is the direction that I am going to go. I at least have it
> working properly
> now. Thanks for input!
>
> ~Dave
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of [EMAIL PROTECTED]
> Sent: Friday, March 16, 2001 10:59 AM
> To: [EMAIL PROTECTED]
> Subject: Re: inserting html into a DB field
>
>
>
>
> Have you thought about building each bill as a separate HTML
> file? Basically
> you'd create an html template, or even a number of templates, with unique
> names
> where you want to place information.
>
> html
> body
>
> Customer Name: 0cust_name
> Biller Name: 0biller_name
>
> etc, etc
>
> /body
> /html
>
> Then use cffile to read the template and rereplace to replace the unique
> names
> w/the corresponding information from your db. Then use cffile
> again to write
> a
> unique html file for each bill, and reference that unique name in your DB
> field.
> You can set this up to run at 2am, and your users will only hit the db to
> get
> the file name for the bill instead of all of the html content.
> I've got the
> code
> for all of this at home, and I know I posted it on the list a few
> months ago
> if
> someone still has it. I'm not sure if this will work for what
> you're trying
> to
> do, but it might be an alternative.
>
> Phil
>
>
>
>
>
> Dave Cahall <[EMAIL PROTECTED]> on 03/16/2001 08:48:29 AM
>
> Please respond to [EMAIL PROTECTED]
>
> To: [EMAIL PROTECTED]
> cc:
>
> Subject: Re: inserting html into a DB field
>
>
>
> After our phone discussion, it appears I think I have a clearer
> understanding of what you are trying to do.
>
> You want to create a customer bill or invoice and put the code in a
> database. You are trying to put the dynamic code
> that creates the bill/invoice in the database (along with the variables)
> so that it can be called from the database later and then
> displayed. You are putting the HTML/CFML code on your page as a long
> string and ColdFusion is interpreting the code rather
> than just inserting it in the database.
>
> If this more clearly describes the situation, then try the following
> approach.
>
> Put your CFML page that creates the bill/invoice out on your server. In
> your original page, use a CFHTTP tag to execute the page
> (passing the appropriate variables). This will cause the page to be
> executed and the results will be returned to you in a variable named
> CFHTTP.FileContent. Now use this variable to store the results in your
> database. This will have the effect of storing all of the HTML code with
> the data already in it. Now to display the bill dynamically, you just
> retrieve the record from your database and display the field contents
> (which in turn will have all of the HTML and data originally generated by
> the CFHTTP tag). In fact, if there are a large number of these, you can
> set up a scheduled process to create the bills/invoices during non peak
> hours and then when the customer wants to view them on-line during peak
> times you should get very fast performance because the only query that
> has to be executed is to retrieve the record that already has the code
> and data in it (no query will be needed to dynamically generate the
> content of the bill/invoice).
>
> Hope my interpretation is on target.
> On Thu, 15 Mar 2001 17:31:42 -0600 "David Shuck" <[EMAIL PROTECTED]> writes:
> > I am trying to insert a chunk of html code from <html> to </html>
> > into a
> > field in a DB. The sql works in a query tool, but fails in CF. In
> > the
> > error debugging on the page where it shows the query, it displays
> > the html
> > like it would if it was outputting it on a page after 'values'. I
> > am
> > assuming that CF is trying to interpret it rather than just consider
> > it a
> > long string of text. I know there is some way to let CF know that
> > it is
> > just raw text, but I am drawing a major blank. Anyone?
> >
> > Thanks.
> >
> > ~Dave
> >
> >
> >
> -------------------------------------------------------------------------
> > This email server is running an evaluation copy of the MailShield
> > anti-
> > spam software. Please contact your email administrator if you have
> > any
> > questions about this message. MailShield product info:
> > www.mailshield.com
> >
> > -----------------------------------------------
> > To post, send email to [EMAIL PROTECTED]
> > To subscribe / unsubscribe: http://www.dfwcfug.org
> >
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
>
>
>
>
>
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
