Enter nick problem into mysql

[adam]

Hey guys and girls

I have made a tcl that enters user information into mysql. But I have a problem when the nick has a \ in it. Mysql requires the value to be set to \\.

Code: Select all

set $nick "ad\am"

## Nick need to be "ad\\am" to go into mysql

I have tryed {$nick} and a regsub a mate try to make. Nothing has worked yet. Any help with this problem would be ace.

Adam

[adam]

Like they say when you give up is when you find it. I am still not sure if this is the correct way. Thanx

Code: Select all

set nick [string map {\\ \\\\ \[ \\\[ \] \\\] \( \\\( \) \\\) \{ \\\{ \} \\\} \" \\\"} $nick]

Adam