[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
>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"
  [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>

maybe you have a problem due to not naming the sql tag params?