[ic] ASP like Perl

Dan Browning interchange-users@interchange.redhat.com
Fri Nov 30 16:59: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

This is just a shot in the dark, but maybe...

	list=1
HTH,

Dan Browning
Kavod Technologies


> 	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.
> ------------------
> 
> _______________________________________________
> interchange-users mailing list 
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>