| Subject: | minor remaining extended placeholder DWIM issue (but workaround available in recent ver is okay, THANKS!) |
the sqlite3 command line utility supports placeholders by using for
instance ?1 to mean the first argument, as if hook was the placeholder
sygill. The DBI docs say use :1 but it isn't portable. Well, neither
works with DBD::SQLite 1.25. I'll try upgrading. ...
Okay, an update of the form
update TABLE set a=? where b=? and a IS NOT :1
compiles but wants four args as if the :1 is a fourth ?
but
update TABLE set a=:1 where b=:2 and a IS NOT :1
works as intended, so that's fine.
Also, there doesn't seem to be any mention of "placeholder" anywhere in
the pod, to state what will and won't go as a placeholder with this DBI
driver.
Good times!