Forum OpenACS Q&A: Response to ArsDigita Templating System

Collapse
Posted by Don Baccus on
The ns_ora calls are probably to the newish aD select and dml driver
API that allows things like:

ns_ora select "select foo from bar where key = :tcl_key"

The driver looks up tcl_key in your Tcl environment.

We've got that implemented in the newest Postgres driver (thanks
mostly to Dan) as ns_pg_bind commands.

There's actually nothing about these commands that are db-specific and
one thing I've discussed with a couple of folks is that eventually we
may just want to extend ns_db to do these tcl-var lookups, at least
for drivers we support for OpenACS.  This implies a fork from the aD
Oracle driver, but a minor one and since aD will not be doing a hell
of a lot of future support work on the driver there's probably no real
cost involved, in practice.

But, for now, we'll use ns_pg_bind.  In ACS 4x the calls are
restricted to the database API anyway (which I've already ported, BTW).