|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!