[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