><SNIP>
>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?

Any system that can read plain text files can access the files used by
listserv. Whether or not you could have changes made and written to the
files and interpreted without a listserv restart I can't say for certain,
but I doubt it based off past experience.

>The reason I ask is because, if I recall correctly, the hook in LISTSERV
>for SQL databases does not include the LISTSERV password (I have notes on
>this but haven't yet revisited them -- if I have this wrong, please correct
>me).  I'm trying to figure out a way to provide users with a single
>password that would work for LISTSERV as well as with other web
>applications that store passwords in SQL 2000.
>
>I'm wondering if my idea my provide a means to read and write passwords
>through ColdFusion.

Only provided the file is not locked up for listserv's exclusive use when
the server is running, and the login details are checked on individual
executions and not just loaded into memory on runtime and checked from there.

>I also wonder if anyone is aware whether or not ColdFusion can be used to
>access the archive data files?

Yes since they're stored as plain text like most other listserv
data/settings files. You'd need to write your own handlers for the files
though.