Обсуждение: openoffice and boolean

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

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

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

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

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