Postgres Pro
Downloads
Home   >   mailing lists

Thread: openoffice and boolean

openoffice and boolean

From
tony
Date:
Hello,

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.

Cheers

Tony Grant

Re: openoffice and boolean

From
Scott Marlowe
Date:
On Tue, 2004-12-28 at 11:14, tony wrote:
> Hello,
>
> 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

or simply

select * from sometable where somefield

Re: openoffice and boolean

From
tony
Date:
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.

Thanks

Tony

Re: openoffice and boolean

From
Kris Jurka
Date:

On Tue, 28 Dec 2004, tony wrote:

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

Could you be more specific on "don't work"?  Does it not return the
expected rows?  Does it throw an Exception?  If so what's the exact
error message?

Kris Jurka

Re: openoffice and boolean

From
tony
Date:
Le mardi 28 décembre 2004 à 15:24 -0500, Kris Jurka 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.
> >
>
> Could you be more specific on "don't work"?  Does it not return the
> expected rows?  Does it throw an Exception?  If so what's the exact
> error message?

Some throw exceptions (java exceptions), some return wrong data type sql
messages.

What I was hoping for was that a person on the list used OpenOffice and
JDBC and had the correct OOo "critera" line for a boolean field. The
number of dialog boxes I saw this afternoon were "many" and "varied"
=;-D

Cheers

Tony Grant