toddwelti

I have been trying to insert backslashes after the $ arguments in the following sql command, that is used in a message box to mxl mysql object

sql INSERT INTO mushra(id\, expFile\,listener_id\, trial\, program\, Arating\, Brating\, Crating\, Drating\, Erating\, Frating\, Grating\, Hrating\, TimeStamp) VALUES(null\, $2\, $3\, $4\, $5\, $6\, $7\, $8\, $9\, $10\, \$11, \$12, \$13, \$14)

Everything works fine up to the $11, which every time I try to enter "$11\", the "\" gets moved to in front of the "$11" when I exit editing the message box. Same for any argument after that. I tried several escape sequences to get it, cannot get it. I've tried copying the text into a new message box, and a bunch of other things. Consistently, any argument higher then the $10 results in the backslash being moved in front of the argument. So weird and I'm out of ideas here.

Everything works fine up to the $11, which every time I try to enter "$11\", the "\" gets moved to in front of the "$11" when I exit editing the message box.  Same for any argument after that.  I tried several escape sequences to get it, cannot get it.  I've tried copying the text into a new message box, and a bunch of other things.  Consistently, any argument higher then the $10 results in the backslash being moved in front of the argument.  So weird and I'm out of ideas here.


message-text-escape-character-weirdness

There are only 9 changeable args [1-9]. You will need to combine smaller lists to have more.

There are only 9 changeable args  [1-9].   You will need to combine smaller lists to have more.


message text escape character weirdness