Anyone know how to trim any character that's not a letter, number,
fullstop, or space from a certain column, in a certain MySQL table ? Turns
out that silly people have been storing their "fullname" in the database
of my email system, with colons, commas etc. You have no idea how much
that upsets Qmail and sendmail. I've stuck some javascript in to stop
people entering it...but that's not much good for the 5000 users that
already could have done it...
Kate
--
"The fool must be beaten with a stick, for an intelligent person
the merest hint is sufficient" -- Zen Master Greg
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
