It's actually pretty easy to do too. We did a quickie of one at
http://www.bighousefan.com
Did it months ago. Doesn't have all the features, isn't even that
pretty, but we were only playing anyway. (see
http://www.bighouse-fanclub.com if you're curious who bighouse is).
As for clearing out the database - if it got busy enough the idea was to
clear out everything older than 30 days automatically. Very simple to
script, but little time to play these days. It does exactly as you say
- pulls the emails out of imail and inserts them into database. moving
from folder to folder, creating new folder, etc is all handled thru CF.
Our particular version of CF is suppose to have a bug with mail
attachments, but haven't run into it yet. An upgrade would eliminate
the possibility (but why fix what ain't broke yet).
We're coding the fancy stuff into another interface on another site.
Tonya
Brent Sadler wrote:
>
> My idea of setting up a customizable interface with Cold Fusion would be to
> just set up the database and when people check their mail with the web
> interface it would place their email into it. The CF Interface could be set
> up in such away as to assign each email to a folder. Basically, it would
> look like folders to the end user, but they would actually be a table in the
> database.
>
> The only downside to all this is that if you have a fairly large group of
> users the database is going to get large pretty quick if people don't erase
> their messages. This would require you to run an Oracle or SQL server
> instead of just using an Access database. For our purposes, most of my ISP
> users only need to be able to access their mail when they are travelling or
> are not at home. This would be perfect for them.
>
> Brent
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
