Forum OpenACS Development: Response to Bind variable emulation in Tcl?

Collapse
Posted by Don Baccus on
Ripping the emulation code out of the PG driver and installing it in nsodbc shouldn't be difficult.

The only requirement is that expressions like:

foo_id = '123'

work, i.e. that integers can be quoted and will be interpreted as numbers.  Oracle and PG both allow this (though the Oracle driver does
real bind vars, of course) and I think it's standard SQL 92.

Doing it at the Tcl level wouldn't be that hard - check out the regexps in the PG or Oracle driver that identify :tcl_var constructs.

But doing it right in nsodbc would be more efficient.