[ic] sql question...

[Jonathan Clark]

>
>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.