Re: openoffice and boolean - Mailing list pgsql-jdbc

From tony
Subject Re: openoffice and boolean
Date
Msg-id 1104265987.3777.26.camel@hush
Whole thread Raw
In response to Re: openoffice and boolean  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: openoffice and boolean
Next
From: "Nico"
Date:
Subject: Re: Open connections