To get an idea !!
<form:column>
<xsp:logic>
doSplit(mychangeticket.core.getProperty("LongDescription").getFormatted(),
"\\\n", xspAttr);
<xsp:content>
<br/><br/>
</xsp:content>
</xsp:logic>
</form:column>
private void doSplit(String text, String sepregexp, AttributesImpl
xspAttr) throws Exception {
String[] lines = text.split(sepregexp);
for (int i = 0; i < lines.length; i++) {
<xsp:content>
<xsp:expr>lines[i]</xsp:expr>
</xsp:content>
if (i != lines.length -1) {
<br/>
}
}
}
-----Original Message-----
From: news [mailto:[EMAIL PROTECTED] Behalf Of Olivier Billard
Sent: 18mm2004 17:45
To: [EMAIL PROTECTED]
Subject: Re: Query wrt rows returned from a database???
Hi Sam,
HTML code doesn't care about "carriage returns"
You should retrive your content in a String, split it with the '\n'
character, iterate through the array, adding <br/> to the content
between each element of the array.
Sam wrote:
> Hello Everybody,
>
> I am still waiting to get a reply back for my query. Would be great if
someone answers this.
> Thanks !!!
>
>
> On Mon, 17 May 2004 Sam wrote :
>
>>Hi List...
>>
>>I can retreive rows from a MySQL database with no problems, only that the
rows returned have no newline character, ie the SQL transformer ignores or
escapes (I am not sure) the newline characters and I get rows fetched from
the database as one single line.
>>
>>Now how do I keep the newline character after every row that is been
fetched through SQL transformer so that I can display it on the browser in a
nice table format ???
>>
>>Does anybody know why & how can I avoid that ???
>>
>>Regards
>
>
---------------------------------------------------------------------
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]
