Re: boolean problem

Le lun 18/10/2004 à 21:18, Kris Jurka a écrit :

> > Postgresql 7.3.2 Mac OSX
> > Tomcat 4.1 Mac OSX
> >
> > My webapp is asking for a boolean and Postgresql is returning "t"
> > interpreted as a string by the application... I though that the JDBC
> > driver took care of little things like that?
> >
>
> It is entirely unclear what you are actually doing?  What ResultSet method
> are you using?  getBoolean, getString, getObject?  How about a couple
> lines of sample code that show what you are doing, what the result is, and
> what you expect the result to be?

<%
Driver Driverhowmanyworks =
(Driver)Class.forName(MM_frac_DRIVER).newInstance();
Connection Connhowmanyworks =
DriverManager.getConnection(MM_frac_STRING,MM_frac_USERNAME,MM_frac_PASSWORD);
PreparedStatement Statementhowmanyworks =
Connhowmanyworks.prepareStatement("SELECT count(*)=1 as works  FROM
oeuvre, cree_par, collection  WHERE oeuvre.oeuvre_id =
cree_par.oeuvre_id  AND cree_par.artiste_id = collection.individu_id AND
collection.nom ILIKE '%" + howmanyworks__varNom + "%'");
ResultSet howmanyworks = Statementhowmanyworks.executeQuery();
boolean howmanyworks_isEmpty = !howmanyworks.next();
boolean howmanyworks_hasData = !howmanyworks_isEmpty;
Object howmanyworks_data;
int howmanyworks_numRows = 0;
%>

And in the page

<% if ((((howmanyworks_data = howmanyworks.getObject("works"))==null ||
howmanyworks.wasNull())?"":howmanyworks_data)) { // Adv Conditional
Region %>

incompatible types
found   : java.lang.String
required: boolean

I have tried with boolean but to no avail

operator == cannot be applied to boolean,

Cheers

Tony Grant

--
www.tgds.net Library management software toolkit