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