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

Collapse
7: Re: reloading xql files in the www directory tree (response to 6)
Posted by Ryan Gallimore on 09/26/06 02:36 PM
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.

Collapse
8: Re: Res: Re: reloading xql files in the www directory tree (response to 7)
Posted by Jose Pablo Escobedo Del Cid on 09/26/06 03:15 PM
You can also use literal variables in the tcl files if you use quotes ("") instead of curly brackets ({}) in your query.
Collapse
9: Re: Res: Re: reloading xql files in the www directory tree (response to 8)
Posted by Ryan Gallimore on 09/26/06 03:20 PM
Thanks, Jose!