I can't see any reason for this. The column is a BIT type in the xml schema?
john mcnally On Thu, 2002-05-16 at 18:11, James A. Hillyerd wrote: > I feel like I am going to spend the rest of my life wrestling with > PostgreSQL and it's boolean type. =) > > The problem I am having is that PostgreSQL does not allow you to use > numbers to describe boolean values. One (no pun intended) must use the > words true and false. > > Currently I am building a Criteria: > > Criteria c = new Criteria(); > c.add(HlnUserGroupPeer.CAN_ASSIGN, true); > > The generated SQL has the following WHERE clause: > > WHERE hln_user_group.CAN_ASSIGN=1 > > Postgres needs: > > WHERE hln_user_group.CAN_ASSIGN=true > > How do I fix this? Can I add some info to the DBAdapter classes and > then modify criteria? Or am I in Village territory here? > > Thanks. > > -james > > -- > [] James A. Hillyerd <[EMAIL PROTECTED]> - Java Software Engineer > [] PGP 1024D/D31BC40D F87B 7906 C0DA 32E8 B8F6 DE23 FBF6 4712 D31B C40D > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
