Le mardi 28 décembre 2004 à 11:52 -0600, Scott Marlowe a écrit :
> > Connecting OOo 1.1.2 to Postgresql via JDBC I can't seem to find the
> > correct OOo query editor criteria for a boolean value. Does anyone know
> > the magic formula? The value in the database is 't'. = TRUE ='t' etc.
> > etc. don't work.
> Those queries are usually of the format:
> select * from sometable where somefield IS TRUE
returns "was expecting - or NULL"
> or simply
> select * from sometable where somefield
I'll try and write that into the non standard SQL editor of OpenOffice.
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2004-12-28 20:23:04|
|Subject: Re: Open connections|
|Previous:||From: Scott Marlowe||Date: 2004-12-28 17:52:36|
|Subject: Re: openoffice and boolean|