Re: databases and `mail merge'

1999-01-11 Thread Chris Frost 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Mon, 11 Jan 1999, Johann Spies wrote:

> Or python using pygres to communicate with Postgres and producing LateX
> output.
This is what I decided to do, thanks! Of course, I need to learn some
python pretty quickly now :)

Chris
<- Visit Me At  ->

<-->
   Public PGP Key:
 Email [EMAIL PROTECTED] with the subject "retrieve pgpkey" or
visit 

-BEGIN PGP SIGNATURE-
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBNpn1d+EzIlbKpewXEQKZbwCgleenOKfhDXb+xlLRYUKAswDgT6kAoLu+
bURGhEWwGCSWw0pQgyPrkHHJ
=L476
-END PGP SIGNATURE-

Re: databases and `mail merge'

1999-01-11 Thread Johann Spies 
On Sun, 10 Jan 1999, Stephen Pitts wrote:

> 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. 


Or python using pygres to communicate with Postgres and producing LateX
output.

Johann

 --
| Johann Spies Windsorlaan 19  |
| [EMAIL PROTECTED]3201 Pietermaritzburg |
| Tel/Faks Nr. +27 331-46-1310 Suid-Afrika (South Africa)  |
 --

 "Enter into his gates with thanksgiving, and into his 
  courts with praise. Be thankful unto him, and bless 
  his name."   Psalms 100:4

Re: databases and `mail merge'

1999-01-10 Thread Stephen Pitts 
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  ->
> 
> <-->
>Public PGP Key:
>  Email [EMAIL PROTECTED] with the subject "retrieve pgpkey" or
> visit 
> 
> -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 [EMAIL PROTECTED] < /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
[EMAIL PROTECTED]
webmaster - http://www.mschess.org

databases and `mail merge'

1999-01-10 Thread Chris Frost 
-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  ->

<-->
   Public PGP Key:
 Email [EMAIL PROTECTED] with the subject "retrieve pgpkey" or
visit 

-BEGIN PGP SIGNATURE-
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBNpkMjeEzIlbKpewXEQJp6ACguSg7rMA9lMMQUhjczOZ7Y5h/s7oAoIuE
BKzhvu/2zYSNbb4VZDIEbAag
=S++i
-END PGP SIGNATURE-