Hi Ron Thanks for the help.
You are on the right track for the VARCHAR -> CHAR. It was my mistake, the datatype in the dev database is CHAR. I've corrected that now, thanks again. Kind Regards Paul Neumeyer Random Sea Pty Ltd T: 02 9939 1988 M: 0418 400 656 [EMAIL PROTECTED] +------------------------------------------------------------------------+ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person. Thank you. +------------------------------------------------------------------------+ -----Original Message----- From: Ron Grabowski [mailto:[EMAIL PROTECTED] Sent: Friday, July 29, 2005 10:47 AM To: [email protected] Subject: Re: Results from ibatis QueryForList pad VARCHAR I haven't experienced this on Access or SQL Server 2000. What database are you using? What version of IBatisNet are you using? Could you supply us with a small snippet of the xml mapping that returns a padding value? It sounds like something is getting changed into a CHAR as opposed to a VARCHAR. --- paul <[EMAIL PROTECTED]> wrote: > I have recently worked on transferring an existing project across to > iBatis.NET. The reason I am writing is that the same SQL run in > iBatis has > VARCHAR values padded to there full database data type length - while > the > direct SQL via ADO returns the stored value at its "correct" length. > > Why is this? How do I ensure the QueryForList returns the values > without > padded? > > Kind Regards > > Paul Neumeyer > > > Random Sea Pty Ltd > T: 02 9939 1988 > M: 0418 400 656 > [EMAIL PROTECTED] > > > +------------------------------------------------------------------------+ > This email may contain information which is privileged or > confidential. > If you are not the intended recipient of this email, please notify > the > sender immediately and delete it without reading, copying, storing, > forwarding or disclosing its contents to any other person. Thank > you. > +------------------------------------------------------------------------+ > >
