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]>
