Forum OpenACS Development: Re: reloading xql files in the www directory tree

Collapse
Posted by Torben Brosten on
Yeah, you can skip using the xql files when placing code in the www directory tree (by placing the sql directly in the statements), since the code is uniquely deployed ..ie not expected to be used anywhere else or on any other platform.
Collapse
Posted by Ryan Gallimore on
I could be wrong, but aren't xql files the only sql situation where you can use literal variables, ie, a variable where clause?

select event_id
from   events
$where_clause

I had no success getting this to work in db_* functions in my tcl files.

You can also use literal variables in the tcl files if you use quotes ("") instead of curly brackets ({}) in your query.
Thanks, Jose!