I've been looking into the database because within Crystal Reports it wasn't outputting all the information from a field. I've now see a pattern where it is this character '□□' which occurs for a new line, I need to remove before the information is submitted to the database.

As the moment this is the code being used:


<textarea cols="56" rows="2" name="txtPersonalMessage" id="txtPersonalMessage" style="font-family:Arial, Tahoma, Helvetica, sans-serif; font-size: 9pt; color:#43291D;"></textarea></td>

Which is posted to a page where this then happens:

PersonalMessage=killChars(Request.form("txtPersona lMessage"))

Which is then submitted to the database and within the query the section relating to the Personal Message is:


The site it built in Classic ASP and we are looking to remove the '□□' for a new line which can be stored an outputted in Crystal Reports.

I look forward to hearing some solutions,