Forum OpenACS Development: Tcl arrays with bind variables?

Request notifications

Posted by Andrew Piskorski on
Is there any good reason you can't use Tcl array variables with bind variables? It'd certainly be nice if you could use them exactly the same way you use non-array Tcl variables.

"where id = :foo_bar" of course works fine, but

"where id = :foo(bar)" doesn't work at all.

Why? Is there some good reason, or was this just an implementation oversight? What would it take to change it, and where would those changes need to be made? The Oracle and PostgreSQL drivers? Elsewhere?