Received: from eta.ece.rice.edu (ece.rice.edu [128.42.4.34])
	by hub.org (8.9.2/8.9.1) with ESMTP id LAA04608
	for <pgsql-interfaces@postgresql.org>;
	Tue, 9 Feb 1999 11:58:46 -0500 (EST)
	(envelope-from reedstrm@rice.edu)
Received: from rice.edu (wallace.ece.rice.edu [128.42.12.154])
	by eta.ece.rice.edu (8.9.0/8.9.0) with ESMTP id KAA16576;
	Tue, 9 Feb 1999 10:55:00 -0600 (CST)
Sender: reedstrm@ece.rice.edu
Message-ID: <36C06936.28913577@rice.edu>
Date: Tue, 09 Feb 1999 10:58:30 -0600
From: "Ross J. Reedstrom" <reedstrm@rice.edu>
Organization: NSBRI
X-Mailer: Mozilla 4.06 [en] (X11; U; Linux 2.0.34 i686)
MIME-Version: 1.0
To: Matthew Hagerty <matthew@venux.net>,
	pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] Rapid web based apps?
References: <4.1.19990208151507.0097e9e0@mail.venux.net>
	<36BF54C7.7AD90D9B@trust.ee>
Content-Type: multipart/mixed; boundary="------------DAD788BF80EBBEECEEEC0D95"

This is a multi-part message in MIME format.
--------------DAD788BF80EBBEECEEEC0D95
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I'll second Hannu's recommendation of Zope - I'm using it right now to
develop some data management pages for a PosrgreSQL database.  The only
caveat is that the Zope->PostgreSQL connector (it's called ZPyGreSQLDA -
that's Zope Python postGreSQL Database Adaptor) is a contributed piece
of code with one show stopper bug - it errors on an empty query return!
I've posted a fix for that on the Zope mailing list, and sent it to the
author. If you decide to try it, fire me a note I can give you the patch
- oh, heck it's a one line additon patch: I'll attach it here.


Hannu Krosing wrote:
<clipped mention of Zope>

-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005
--------------DAD788BF80EBBEECEEEC0D95
Content-Type: text/plain; charset=us-ascii; name="db.py.diff"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="db.py.diff"

--- ZPyGreSQLDA/db.py~	Wed Jan  6 20:29:37 1999
+++ ZPyGreSQLDA/db.py	Tue Jan 26 11:16:12 1999
@@ -182,6 +182,7 @@
             raise sys.exc_type, sys.exc_value, sys.exc_traceback
 
         if desc is None: return (), ()
+        if not result: return (), ()
 
         items=[]
         func=items.append

--------------DAD788BF80EBBEECEEEC0D95--