Subject: | |
From: | |
Reply To: | |
Date: | Tue, 17 Aug 2004 13:52:04 -0700 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
At 12:47 AM 8/16/2004, Michael Shannon wrote:
> >
> >It's occurred to me that rather than hook LISTSERV to SQL 2000, I could
> >leave the data in its native flat table and instead hook ColdFusion
> >directly to it somehow. The idea occurred to me last night as I was
> >reading a book on ColdFusion. The author wrote that ColdFusion is capable
> >interfacing with a broad array of database types -- including
> >ASCII-delimited files. Does anyone know if ColdFusion is capable of
> >linking to the LISTSERV database flat file?
> >
>
>No, this isn't possible. CF can certainly try to access the file but the
>problem lies in the fact that it's not plain-text at all. It's a special
>binary format that, if modified outside of LISTSERV, can do Very Bad Things
>to your list (ie. it WILL break down).
You don't have to tell me twice! <g> I won't even consider this
direction, then. I'll set up LISTSERV to store subscriber data in SQL 2000
then, and tie ColdFusion to SQL 2000.
> >I also wonder if anyone is aware whether or not ColdFusion can be used to
> >access the archive data files?
>
>Archive files are a different story as they _are_ plain text. You can
>grant access to the Notebook files of a list and read them but you will
>have to be very careful if any modifications are made.
Ok, good.
>If you do modify the Notebook then you'll have to at least GET/PUT the list
>header to force a re-index of the files. Failing to do this can cause the
>Digests and web archives to be corrupted.
Got it.
Thanks Michael.
Steve
Stephen C. Nill, J.D.
Founder & Chief Executive Officer
[log in to unmask]
CharityChannel.com - Connecting Nonprofit Professionals Worldwide (tm)
|
|
|