Index: openacs-4/packages/acs-core-docs/www/db-api.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/db-api.html,v diff -u -r1.53.2.5 -r1.53.2.6 --- openacs-4/packages/acs-core-docs/www/db-api.html 1 Nov 2019 13:16:18 -0000 1.53.2.5 +++ openacs-4/packages/acs-core-docs/www/db-api.html 3 Sep 2021 09:14:55 -0000 1.53.2.6 @@ -115,13 +115,13 @@ cannot change the actual text of the query, only the literal values in the placeholders. The database API makes bind variables easy to use by hooking them smoothly into the Tcl - runtime so you simply provide :tclvar and the value of $tclvar + run time so you simply provide :tclvar and the value of $tclvar is sent to the backend to actually execute the query.
The database API parses the query and pulls out all the bind variable specifications and replaces them with generic placeholders. It then automatically pulls the values of the named Tcl vars out of the - runtime environment of the script, and passes them to the database. + run time environment of the script, and passes them to the database.
Note that while this looks like a simple syntactic change, it really is very different from how interpolated text queries work. You use