RE: [ic] ASP like Perl

[Korey Gozman <korey@awpg.com>]

Even with the list=1 it still resolves to the last field in the table

so I started to try a different type of query

[perl tables=table001]
         my $sql = "select * from table[item-code] where filename = 1";
         my $results = $Tag->query( { sql => $sql } );
         my ( $same_results, $col_name_hashref, $col_name_arrayref) = 
$Tag->query( { sql => $sql, } );
         my $hash_results = $Tag->query( { sql => $sql,
                                           hashref=> 'my_results' });
return $Tag->uneval($results);
[/perl]

and even with this one, it still displays only the last matching record
is there something that Im doing wrong


At 14:00 11/30/01 -0800, you wrote:
> > 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
> >
>
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users

_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users