[ic] ASP like Perl

Korey Gozman interchange-users@interchange.redhat.com
Fri Nov 30 15:13:01 2001


Ok So I figured out how to pull
fields from a table but now Im
having a problem of a different sort,

I want to pull all the fields that match the criteria
but it only displays the last entry in tha table.
any suggestions?


My Query
---------------------
  [query sql="SELECT variable, value from table001 where variable = 'cont' "
	type=list
	more=1
	ml=10]
		
	 [on_match]
		Matched<br>
		<table border="1">
		 <tr>
		[/on_match]
		
	 [no_match]Not Found<br>[/no_match]
		[list]
				<td>[sql-param value]</td>
		[/list]



	[on_match]
		</tr></table>
	[/on_match]
	 [more_list]
	   [more]
	 [/more_list]
   [/query]
------------------

My Table
------------
variable        value
cont    Panel Thickness
cont    .040" - .057"
cont    .040" - .110"
cont    Punched Hole
cont    .358" - .353" sq.
cont    .377" - .375" sq.
------------------