December 17th, 2012, 03:19 AM
Unknown chatachter '□□' being entereed into the database instead of a NEWwasn line
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:
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,