[ic] sql question...
Jonathan Clark
jonc@webmaint.net
Sun, 26 Nov 2000 12:00:12 -0000
>
>I am not so sure you will be able to embed the second query using results
>from the first. If it doesn't work, you should be able to set a scratch
with
>the first query that is read by the second though.
>
I have no trouble with this:
[sql type=list query="select * from area where sel='left' order by sort"
prefix=area]
[area-exec bar_link]area[/area-exec]
[sql type=list query="select * from cat where sel like '%[area-code]%'
order by sort" prefix=cat]
[cat-exec bar_link]cat[/cat-exec]<br>
[/sql]
[/sql]
maybe you have a problem due to not naming the sql tag params?
Jonathan.