If I try the following ZSQL method it displays de authorization window:
<dtml-let Cl=”get_Cliente(N_='22606')[0]”>
select * from Cliente where N_='22606'
</dtml-let>
but if I try the next ZSQL method it displays the correct result (the difference is the integer index in the first line):
<dtml-let Cl=”get_Cliente(N_='22606')”>
select * from Cliente where N_='22606'
</dtml-let>
As you can see the “dtml-let” isn't usefull, but this is a simplified example.
For reference here is the get_Cliente ZSQL method:
select * from Cliente where <dtml-sqltest N_ type=string>
Very simple.
Thank you in advance.
