Re: [ic] sql question...

[Paul Stearns <pauls@compuace.com>]

Johnathan:

Thanks... I'll try it...

Paul

Jonathan Clark wrote:

> >
> >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.
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users


_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users