[Israel.pm] DBI

jaime.prilusky at weizmann.ac.il jaime.prilusky at weizmann.ac.il
Sun Oct 31 03:35:08 PDT 2010

According to "Chanan Berler" <bc.other at gmail.com>:
> I am running DML queries using binary data, that might include ' or "
> or ` characters.
> I remember there is a DBI method, that fixes these characters, so
> there won't be any syntax errors...

I would suggest to bind the query data using placeholders. This
takes care of these characters.

 Dr Jaime Prilusky                      | Jaime.Prilusky at weizmann.ac.il
 Head Bioinformatics                    |
 R&D Bioinformatics and Data Management |
 Department of Biological Services      |
 Weizmann Institute of Science          | fax: 972-8-9344113
 76100 Rehovot - Israel                 | tel: 972-8-9344959

 OCA, http://oca.weizmann.ac.il (the protein structure/function database)
 Proteopedia, http://proteopedia.org (because life has more than 2D)

More information about the Perl mailing list