The code looked ok to me. I think it is an environment problem. Either
its case sensitivity or the csp application configuration is incorrect
and therefore you are not running the code in the place you think you
are so no data is found for the csp page?
Bernd Mueller wrote:
Hey Leonardo,
Leonardo J. Tramontina wrote:
Bernd,
The "%" before the ID, is because the query was created by Studio. Every
query you create and use the ID, it generates the sql code addinf the
"%".
ok! I don't know that point.
And about the "", sorry but I didn't understand...
Sorry i am unclear ... i mean those Joins enclosed in quotation marks :
"NivelAcesso->ID","NivelAcesso->Descricao","MenuPai->Descricao" ...
but i assume the studio query wizard added them as well. So this also
seems ok ;-)
Cach� Win XP: 5.0.5
Cach� Red Hat 9.0: 5.0.5
ok ... same versions ... thats also fine!
Please try and test :
- Remove <csp:query> and add <script language=sql ...>
- What about the html-source of the menu-page? Is there any menu stuff
there ?
- Are you sure your %session-data and %request-data you use is correct ?
- The query works when issued from terminal ?
Thanks and Regards ...
Bernd!
instead. I don't know why you use %ID and "" for some fields in your
Query!?!?! I also added some alias to avoid
name conflicts.
Looping over the result-set is the same.
For testing purposes you can also add
<server>
Set %response.TraceDump=1
</server>
before </body> to ensure and control the values in your %session- and
%request-data.
What cache versions/releases are running on the win- and linux-system ?
Thanks and Regards...
Bernd!
