Hi Thomas, I am using Postgre 8.0.1 for Windoze, Torque 3.1.
In my Torque schema I use data type BOOLEANCHAR, but the field in the database itself is boolean. I don't think there is a 'boolchar' option, or anything similar in Postgre. I guess that's why it's crashing. Ideally Torque would recognize that it is a boolean field and not try to perform an UPPER() on it. Incidentally, I registered for an account on scarab and got a message to confirm my subscription. Unfortunately the link sent in the confirm email is wrong: http://localhost:38080/scarab/issues/template/Confirm.vm/confirm/... localhost!? I tried putting issues.apache.org and www.apache.org instead of localhost but it doesn't work. Any idea? Tanky, Bob @seitenbau.net> wrote: > > > > > Robert, > > Which database and Torque version are you using ? > To my knowledge, booleanchar is usually implemented > as a char field in the > database (at least for oracle and Torque 3.1.1), so > upper should work > there. > > by the way, Scarab is the issue tracker for torqe: > http://issues.apache.org/scarab/issues > request a role as observer for Torque->Source and > then you are able to > create issues > > Thomas > > > > Robert Bowen <[EMAIL PROTECTED]> schrieb am 31.03.2005 > 11:03:00: > > > I *am* using BOOLEANCHAR, and it still doesn't > work. > > > > I'll have to take a look at scarab, don't know > what it > > is! > > > > syg > > > > --- Thomas Fischer <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > Sounds like a bug to me. Can you please enter > this > > > in scarab, including the > > > database and the torque version you use ? > > > > > > As a workaround, you can try to change your > > > datamodel such that you use the > > > data type booleanchar instead of boolean. > > > > > > Thomas > > > > > > Robert Bowen <[EMAIL PROTECTED]> schrieb am > 31.03.2005 > > > 10:02:13: > > > > > > > Hello all. I have a class that sets a whole > bunch > > > of > > > > conditions for a search. Most of the fields I > > > search > > > > on are text so using Criteria.setIgnoreCase() > has > > > been > > > > working. > > > > > > > > I recently added another search criteria, on a > > > boolean > > > > field: > > > > > > > > criteria.add(NotificationPeer.IS_COMPLETE, > false); > > > > > > > > But since the setIgnoreCase() is set to true > for > > > the > > > > Criteria, Torque tries to do an UPPER() on a > > > boolean > > > > field! > > > > > > > > Can I avoid this somehow? Currently it crashes > in > > > a > > > > rather ugly way ... > > > > > > > > Thanks! > > > > syg > > > > > > > > > > > > > > > > __________________________________ > > > > Do you Yahoo!? > > > > Make Yahoo! your home page > > > > http://www.yahoo.com/r/hs > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: > > > [EMAIL PROTECTED] > > > > For additional commands, e-mail: > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: > > > [EMAIL PROTECTED] > > > For additional commands, e-mail: > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Small Business - Try our new resources > site! > > http://smallbusiness.yahoo.com/resources/ > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
