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)