[ic] embedding sql queries

Josh - 185 Performance josh at 185performance.com
Fri Jan 2 18:01:45 EST 2004


I can't find any docs on whether embedding sql queries is allowed.  For
example, I'd like do a simple query:

[query sql = "select distinct manufacturer from correlation order by
manufacturer" list=1]
  Hello, world!  We're now looking at manufacturer [sql-pos 0].
  Included models are:
  [query sql = "select distinct model from correlation where
   manufacturer='[sql-pos 0]'"]
  [/query]
[/query]

I'm sure there's a way, possibly something like [query.1  yadda
yadda...].  Or possibly, a way to export the various sql-pos results?

The ultimate goal here is to build cascading dropdowns driven by
Javascript.  The four dropdown categories will be: manufacturer, model,
year, trim.

Many thanks,
Josh

-- 
Josh McClain
185 Performance
Celica Big Brakes Now Available!
http://http://www.185performance.com/cgi-bin/185p/BRKCEL9093
josh at 185performance.com
www.185performance.com



More information about the interchange-users mailing list