Yes I know this is a little off-topic, but also a little on-topic...
I have a user who likes to use the 'less than' sign ( < ) in notes he enters into the DB.
When I print them out to a web page, they are interpreted as an HTML code and everything after them '<' is not printed.
I'm currently using:
replace(replace(NoteText, '<', '<'), '>', '>') as NoteText
to replace the offending characters with HTML escape codes. Is there a cleaner way of doing this?
Thanks!
Dan
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]