Re: databases and `mail merge'
On Sun, Jan 10, 1999 at 02:24:41PM -0600, Chris Frost wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I'm setting up a database of prospective colleges and would like to be
> able to grab info from the database and somehow insert it into generic
> documents. Ideally, it would be inserted into latex documents and fetch
> the info from PostgreSQL, but if there's a strong need to use another
> set of programs for this task, it'll do.
>
> As an example, I'd like to be able to grab the address info which would
> come from several fields (ie state, city, address, college_name) and
> insert into my document for some condition (whether it be everything, all
> schools with a certain mean sat range or whatever).
>
> thanks,
> Chris
> <- Visit Me At <http://www.frostnet.advicom.net/chris/> ->
>
> <------------------------------------------------------------------------------>
> Public PGP Key:
> Email chris@frostnet.advicom.net with the subject "retrieve pgpkey" or
> visit <http://www.frostnet.advicom.net/chris/pgp_key.phtml>
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBNpkMjeEzIlbKpewXEQJp6ACguSg7rMA9lMMQUhjczOZ7Y5h/s7oAoIuE
> BKzhvu/2zYSNbb4VZDIEbAag
> =S++i
> -----END PGP SIGNATURE-----
>
>
> --
> Unsubscribe? mail -s unsubscribe debian-user-request@lists.debian.org < /dev/null
>
Two options for you:
1. Use something like PHP3 to create an HTML file, then print from netscape.
2. Use embedded perl (I think its in the eperl package) to embed commands from the perl packages for Postgres (check CPAN http://www.perl.com/CPAN for the Perl Database packages)
Hope this helps. Your idea is neat! Perhaps release the database as public domain. In a few months, with volunteers, it could encompass several hundred schools.
--
Stephen Pitts
smpitts@midsouth.rr.com
webmaster - http://www.mschess.org
Reply to: