>> Only use placeholders. $dbh->quote() is unreliable (and this fact is
>> documented in DBI documentation).
PD> Please show me the part of the documentation that you're referring to,
PD> and please supply a counter-example. quote() is extremely useful for
PD> producing SQL statements that will be executed by another program, a
PD> situation for which placeholders are useless.
perldoc DBI:
Quote will probably not be able to deal with all pos-
sible input (such as binary data or data containing
newlines), ...................... There is no need to
quote values being used with the Placeholders and Bind
Values entry elsewhere in this document.
Here a proof that quote sucks:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msp:73935:phlgjhgmdiikjknclakk
User had trobles with quote and binary data but once he rewrote code
with placeholders problem disappeared.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/) |
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 |
| AGAVA Software Company (http://www.agava.com/) |
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
