Just another addition, I just committed the change Luca proposed. It works for him, so perhaps you can try as well.
Thanks Carsten > -----Original Message----- > From: Carsten Ziegeler [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 13, 2003 3:19 PM > To: [EMAIL PROTECTED] > Subject: RE: cvs > commit:cocoon-2.0/src/java/org/apache/cocoon/transformation > SQLTransformer.java > > > > > > > Hmmm... If you need it, somewhere I have a "collapseWhitespace" > > > implementation that we use... It's equivalent to trim plus replaces n > > > occurrences of Char.isWhitespace(x) with a single space char... > > > > > Great! I guess that's exactly what we need. > > Ehm, just one thought: Is it ok to collapse all whitespaces of the > > sql query? Or should we only collapse whitespaces outside of " or ', > > so for example a statement like text = "ggg hhh yyy", should > > not be collapsed to text = "ggg hhh yyy". This is really more > > complicated than it should. > > > Luca just suggested to simply use a > String query = StringUtils.replace(sb.toString(), "\r", " ", -1); > > which could solve the problems as well. > > Hmm > Carsten > >
