r> I was not aware of placeholders, and the benifits of using them instead of
r> using $dbh->quote(). It doesnt make sence that the DBI version of quote isnt
r> as thorough as having the code behind placeholding do it.
I'm not DBI guru but I've seen that quote() doesn't quote some data
correctly. Replacing it with placeholders fixed a problem. BTW fact
that quote is not releable is mentioned in DBI docs (perldoc
DBI). This is quote from there:
Quote will probably not be able to deal with all pos-
sible input (such as binary data or data containing
newlines), and is not related in any way with escaping
or quoting shell meta-characters. There is no need to
quote values being used with the Placeholders and Bind
Values entry elsewhere in this document.
r> But anyhow, I have
r> a few questions as to how this works. Here is an example from the Perl
r> DBH::mysql docs:
r> my @names = ['Flaherty', 'Jones', 'Smith'];
r> my $sth = $dbh->prepare("UPDATE contact
r> SET phone = '555-1212'
r> WHERE last_name = ?");
r> $sth->execute(@names);
r> $sth->finish;
Where did you found this example? I've not found it neither in man DBI
nor in man DBD::mysql.
AFAIK this example is just incorrect. For each placeholder you pass to
'execute' only one single scalar. Check man DBI chapter (Placeholders
and Bind Values) for info on placeholders usage. It has some examples.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| 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
