 |
Michael Nelson
Novice
Joined: 03 Oct 2005
Posts: 36
|
 Posted: Sun Oct 12, 2008 8:18 pm
query problems
|
This won't work.
Doing:
$querystring = %concat("&name ='",$area_name,"'")
#show $querystring
#show %query($querystring)
Shows:
&name ="TEST S'TORE"
<blank>
Doing:
#show %query(&name ="TEST S'TORE")
Shows:
20ar
Also they syntax highlighter shows $querystring as green which is wierd should be blue
Thanks |
|
|
|
|
Vijilante
SubAdmin
Joined: 18 Nov 2001
Posts: 5182
|
Posted: Sun Oct 12, 2008 8:26 pm
|
Your description is leaving me confused as to what is a problem. You see to be saying a particular %query doesn't work, but are also saying it returns a valid result.
I am quite at a loss as to how to help you at this point. |
|
_________________
The only good questions are the ones we have never answered before.
Search the Forums |
 |
|
|
Michael Nelson
Novice
Joined: 03 Oct 2005
Posts: 36
|
Posted: Sun Oct 12, 2008 8:28 pm
|
The query works if I put the value of $querystring in directly if I try and use $querystring it fails
|
|
|
|
|
Michael Nelson
Novice
Joined: 03 Oct 2005
Posts: 36
|
Posted: Sun Oct 12, 2008 9:06 pm
|
%query is refusing to expand variables. I know this because #show %query(@testvar) returns all rows no matter what I put in @testvar also putting %expand(@testvar,1) does not work.
|
|
|
|
|
Michael Nelson
Novice
Joined: 03 Oct 2005
Posts: 36
|
Posted: Sun Oct 12, 2008 10:32 pm
|
posted a workaround for this issue
|
|
|
|
|
|
|
|
