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!
