Re: extra line and carraiage return \r\n\r\n added to data

[darren l]

hello ram,

thanks for that. I am just wondering how I can implement TRIM into my jsp.

For my resultset i have

ResultSet rs1 = stmt.executeQuery("select * from "+Dbase+ " where TLP='" + Page + "'");

how can i add trim to this statement?

the textfield that is effected is
Body_big = (rs1.getString("Body_big")!=null)?rs1.getString("Body_big"):"";

do i apply trim to the select and thereby the who recordset or to the string?

thanks again