[IC] sql-queries in interchange
Korey G.
interchange-users@interchange.redhat.com
Sat Dec 29 14:42:00 2001
Sorry for reposting
I hit send by accident
(Stupid Eudora)
Is there any way to 'head' (or to 'cat' or to 'pipe' ) the
names of fields in an arbitrary database and to use
that information in a list like so maybe
<table>
<tr>
[loop list=[scratch NamesPulledFromDatabase]]
<th>[item-list]</th>
[/loop]
</tr>
[query sql="select * from AbitraryTableNumber1"
type=list
list=1
more=1
ml=1000]
[list]
<tr>
[loop list=[scratch NamesPulledFromDatabase]]
<td> [sql-param [item-loop]]</td>
[/loop]
</tr>
[/list]
[/query]
</table>
Or Perhaps there is a better way of doing this with Just sql Queries
ThXiA
-Korey