Forum OpenACS Development: Problem escaping character in xql

Collapse
1: Problem escaping character in xql
Posted by Mario Aguado on 11/15/06 12:52 PM
I have a problem with "[" and "]" characters in xql files. Those characters are in select clause for present information. Ex. select lfc.role_v || ' ' || '[' || lfc.role_s || ....
This sentence works perfectly in sqlplus and tcl files but I don't find away to escape this characters for this sentence works in xql.

Sorry for my bad english and thanks in advance.

Collapse
2: Re: Problem escaping character in xql (response to 1)
Posted by Dave Bauer on 11/15/06 01:54 PM
If you are building a string, sometimes it is easier to do it in Tcl after the query.

You should be able to escape the [ ] with a backslash like this \[ \].