This makes perfect sense, thanks Dave. I am using Access 2000,
do you think this will cause any problems as the list/post grows?
Kristin
----- Original Message -----
From: Dave Notik <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 28, 2000 3:19 PM
Subject: RE: Mailing list archive
> Technically, you can use CFFILE and write to a file directly. You'd want
to
> write HTML to the specific file and format it as you wish. The negative
> side of this is that you won't have flexibility later on when working with
> the data, and you won't be able to perform conditions (or at least not
> easily) on the data, dynamic formatting and display and so on.
>
> Why not just create an additional table in your database? Storing these
> archives in your database ultimately gives you much more coding
flexibility.
>
> -Dave
> -VBHelp.com
>
> -----Original Message-----
> From: Splash! Designs Ink. [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, May 28, 2000 2:25 PM
> To: [EMAIL PROTECTED]
> Subject: Mailing list archive
>
>
> I would like to archive the data input to a form & sent to a mailing list
> using <CFMAIL>? For example, I have a mailing list where the
> list owner sends out a message to the list via a web-based form.
> This works great, but, I would also like to capture the data &
> have it write to an archive page at the same time. Can this be done
> without setting up another database? Or would I have to have
> the form variables write to a database and then use a query/output
> sequence to display the data?
>
> thanks,
> Kristin
> [EMAIL PROTECTED]
>
>
>
> --------------------------------------------------------------------------
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
