egghelp/eggheads community

sql and special chars

2002-09-29T12:34:25-04:00

The moral of this story, is to read the documentation.

All Tcl documentation, states what a command will return. IE, string, list, multiple dimentional list.

Statistics: Posted by ppslim — Sun Sep 29, 2002 12:34 pm

sql and special chars

2002-09-29T08:11:26-04:00

ok, found the function
had to use [mysqlescape $variable] .. but now a new problem has arisen :/

when I retrieve the text I put in the sql db back I get it like {he's bla bla bla bla} as a string.. with those {} :/
how can I msg that to a person without those {} ?

----
Hmm, I was trying some more stuff and apparantly found it:)
set something [mysqlnext $db]
[lindex $something 0] <- got me what I needed

Statistics: Posted by slashem — Sun Sep 29, 2002 8:11 am

sql and special chars

2002-09-29T07:28:12-04:00

Read the package documentation.

There should be a command prvided, that will excape any characters for you, so that the message is designed to be sent to a MySQL server.

In this situation, only the $message variable should be passed throuhg this function.

Statistics: Posted by ppslim — Sun Sep 29, 2002 7:28 am

sql and special chars

2002-09-29T07:22:30-04:00

I'm using some tcl-mysql package (mysqltcl)

which funtion for escaping characters are you pointing to ?

the only code that generates the error is
"insert into msgs ( msgcontents ) values ('$message')" because $message contains words with a ' in it

Statistics: Posted by slashem — Sun Sep 29, 2002 7:22 am

sql and special chars

2002-09-29T07:11:52-04:00

This all depends on the MySQL interface you are using.

Are you using a MySQL library for Tcl, or writting to a file, and sending it to the MySQL application?

Using a Tcl package is by far the most simple, and the best way about creating a fix. To do so, you should use the function provided, for escaping caracters.

For writting to a file (or direct to stdin on the mysql app), it would all depend how you handled the incoming text.

First, follow the rules for lists, as defined in the FAQ entry on the forum. If you can't work out how, you should paste the script, that is haviong trouble, and we can give pointers.

Statistics: Posted by ppslim — Sun Sep 29, 2002 7:11 am

sql and special chars

2002-09-29T05:41:42-04:00

I'm making some kind of !msg bot where members can use !msg to send msg's to offline users and when the users join the channel they'll get there message..

I'm having a problem with adding messages that contain special characters to the mysql database...

"insert into msgs ( msgcontents ) values ('$message')" doesn't work when theres's a word like " he's " or " it's " in the $message ..

anyone know how to work around this so that those words with special chars can get added and retrieved normally ?

thx in advance

Statistics: Posted by slashem — Sun Sep 29, 2002 5:41 am