[loop] within [sql list]?

[August Detlefsen <augustd@idiom.com>]

I am trying to use a construct like this:

[sql type=list query="select all * from products order by [scratch sortby]"]

<TR>
[loop arg="[db-heads]"]
<TD>[sql_param [loop-code]]</TD>
[/loop]
</TR>

[/sql]

The sql list returns exactly the results it should, and the loop iterates through the database column headings perfectly, the problem is that they don't seem to work together. The resulting output looks like:

<TR>
<TD>[sql_param code]</TD>
<TD>[sql_param description]</TD>
<TD>[sql_param image]</TD>
...
</TR>

Is there a way to force these to interpret? I tried enclosing the sql_param tag in an extra set of brackets, and adding 'sql     1' to %Interpolate in Parse.pm (which came the closest, except that it screwed up all the other uses of sql on the page)...

[field name="[loop-code-a]" code="[sql-code]"]

Works, but it seems to be taking values from the ascii file and not from the SQL.

Any ideas? 
-August
--
 mailto:augustd@idiom.com