I want to replace all ' by \' ? (I need it to do inserts in mysql).
Thanks for help.
What interface to MySQL are you using? I know that the Ruby DBI
module allows you to use place-holders in queries, and the DBI layer
does the escaping for you e.g.
dbh.do("INSERT INTO people (id, name, height) VALUES(?, ?, ?)",
nil, "Na'il", 76)
The resulting statement produced by do and sent to the server looks
like this:
INSERT INTO people (id,name,height) VALUES(NULL,'Na\'il',76)
(stolen from
http://www.kitebird.com/articles/ruby-dbi.html) or if
you are using the ruby mysql interface then (from http://
www.kitebird.com/articles/ruby-mysql.html)
Using escape_string, the platypus record might be inserted as
follows:
name = dbh.escape_string("platypus")
category = dbh.escape_string("don't know")
dbh.query("INSERT INTO animal (name, category)
VALUES ('" + name + "','" + category + "')")
Hope this helps,
Mike
--
Mike Stok <
[email protected]>
http://www.stok.co.uk/~mike/
The "`Stok' disclaimers" apply.