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)