Zugg Software :: View topic

Novice Joined: 03 Oct 2005 Posts: 36

I am fairly certain %query() does not expand its string parameter. This had me pulling my hair out. They way I got around it is as follows:

Here is an example of a failed query,

queryString =%concat("&name=""", $area_name, """")
#show %query(@queryString)

This uses the literal value @queryString for the query thereby failing miserably.
This is the workaround,

$executestring = %concat("%query(&name =""",$area_name,""")")
#show %exec($executestring)

Hope this helps people who have were are flustered as me :)

Posted: Mon Oct 13, 2008 4:39 pm

You are correct. I just checked the command database for CMUD and verified that %query (and #QUERY) is taking a "literal" argument instead of a "string" argument. This prevents it from expanding variables. This has been fixed for the next version.

Novice Joined: 03 Oct 2005 Posts: 36

Thank you for your attention to this issue Zugg.

Posted: Sun Dec 14, 2008 3:35 pm

I can use normal variables successfully in a query string, but local variables don't seem to work still (at least not directly in the query string).

Works:

SubAdmin Joined: 18 Nov 2001 Posts: 5182

The local variables will not expand in quotes. When %query actually does its thing is a little bit later, you could think of the %query function as a complex script that looks something like:
set db view
clear result
dbfirst
while rec do
if @originalQuery then add record number to result
db next
end
return result

When you consider it in that context the local variable is not actually in scope. Also I think %query doesn't know about local variables because it can't create/modify variables directly.