Message-ID: <20010223174824.37559.qmail@web12504.mail.yahoo.com>
Date: Fri, 23 Feb 2001 09:48:24 -0800 (PST)
From: Lonnie Cumberland <lonnie_cumberland@yahoo.com>
Subject: Re: www-sql question 
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@postgresql.org
In-Reply-To: <28260.982944892@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Hello Tom,

thanks for taking a look at www-sql as I was going to use as a quick solution
to having to write so much code, but now a better solution seems to have
presented itself and should work without any problems with PostgreSQL.

I was initially looking at an application called MetaHTML, but the developers
had not really done anything with it for a long time until recently.

They have just released (opensource) and working version MetaHTML 6.10 which
compiles fine and is very easy to install. This particular piece is MUCH more
advanced than www-sql which really need a major re-work.

I found out, with www-sql, that it would not return any error messages or
results of the query, but that when I compiled up your examples in the libpq++
directory and made a few simple changes to reflect that same database which
www-sql used, I could easily get the data from the database.

This led me to think that there was some compatibility issues along with the
age of development of www-sql as well. 

In any case, it is all academic now and I will be using the NEW MetaHTML
release for our project with PostgreSQL.

Thanks for the effort,
Lonnie


--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Lonnie Cumberland <lonnie_cumberland@yahoo.com> writes:
> > The problem is that I am not getting any error messages and it is not
> > returning any data from the database.
> 
> > It appears that there has been some changes in the way that things are
> being
> > done since the last www-sql version had been released.
> 
> I pulled down www-sql-0.5.7 and took a very quick look at its pgsql.c
> module, and didn't see any obvious silliness.  I don't have time to try
> to run a real test though.  Try running the postmaster with -d2 (and
> without -S) so that queries are logged in the postmaster log, and then
> look to see what queries are being received from the www-sql client.
> 
> BTW, you are running www-sql with a recent libpq library compiled into
> it, no?
> 
> 			regards, tom lane


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/