IBatisNet has support for replacing the built-in type handlers: <typeHandlers> <typeHandler type="String" callback="TrimStringTypeHandlerCallback" /> </typeHandlers>
TrimStringTypeHandlerCallback could be implemented in such a way that it automatically calls trim() before sending values to the database. You could continue to use the normal #property# syntax without having to specify the type handler using parameter maps and/or inline parameter settings. Here's a list of some other useful default type handler replacements I thought of: http://www.mail-archive.com/user-cs%40ibatis.apache.org/msg00392.html I don't believe the Java version has this functionality. --- Gareth Moorst <[EMAIL PROTECTED]> wrote: > Before acting on this e-mail or opening any attachments you are > advised to read > The Caudwell Holdings group of companies' disclaimer at the end of > this e-mail. > ======================================================= > > So it does... I hadnn't spotted that. > > One downside of doing it that way is that I can't use select * > anymore, but suppose I'll have to live with that. > > Ta. > > -----Original Message----- > From: Daniel Henrique Ferreira e Silva [mailto:[EMAIL PROTECTED] > Sent: 26 October 2005 13:34 > To: [email protected] > Subject: Re: calling trim() on sql map returned strings > > > Hi Gareth, > > Doesn't Informix have a trim-like function you could apply in your > query? > > Like: > > select trim(mycolumn) as mycolumn from mytable > > Doing that kind of stuff in the database is the best pick IMHO. > > Cheers, > Daniel Silva. > > On 10/26/05, Gareth Moorst <[EMAIL PROTECTED]> wrote: > > > > It would appear that I didn't make myself at all clear in that last > email - it must still be too early in the day for rational thought... > > > > what I want to do is call trim() on all the strings I return from > the db. > > > > -----Original Message----- > > From: Gareth Moorst > > Sent: 26 October 2005 10:01 > > To: [email protected] > > Subject: calling trim() on sql map returned strings > > Hi > > > > All my iBatis created objects have large amounts of spaces in their > string properties, because that is what my informix db returns - I > was just wondering if I need to make a custom type handler to do this > for me, or is there an easier way? > > > > Cheers
