SQL Statement Placeholders

[DougE]

Is there any advantage, performance or feature, that would provide a reason to use the ? or :holder format?

ex 1:

ses << "INSERT INTO Student (sFirst, sLast, sID) VALUES( ?, ?, ?)",
use(first), use(last), use(id), now;
-or-

ses << "INSERT INTO Student (sFirst, sLast, sID) VALUES(:first, :last, :id)",
use(first), use(last), use(id), now;

ex 2:

ses << "SELECT sFirst, sLast, sID FROM Student where sLast = ?",
use(lastlookup), into(first), into(last), into(id), now;
-or-

ses << "SELECT sFirst, sLast, sID FROM Student where sLast = :last",
use(lastlookup), into(first), into(last), into(id), now;

Thanks,
Doug

[alex]

> Is there any advantage, performance or feature, that would provide a reason to use the ? or :holder format?

'?' is the only portable (i.e. standard) way. ':holder' is convenient, but not all DB backends support it.