[ic] ASP like Perl - Loop and Query why can I do both

Korey Gozman interchange-users@interchange.redhat.com
Mon Dec 3 21:40:01 2001


Im trying to do this and it just wont work

note: __TABLE_001__ is a comma separated list

[query sql="SELECT * from table001  "
         type=list
         list=1
         more=1
         ml=1000]


                 [list]
                         [perl]
                         $Tag->loop(
                                 {
                                  list => __TABLE_001__
                                 },
                                 for(@list) {[sql-param 
$list]}
                         )
                         [/perl]
                 [/list]

[/query]


reason being is that I tried to do a regular loop like so
**
[query sql="SELECT * from table001  "
         type=list
         list=1
         more=1
         ml=1000]


                 [list]
                         [loop list=|__TABLE_001__|]
                                 [sql-param [loop-code]]
                         [/loop]
                 [/list]

[/query]
**

and it completly baffles me why it would print this :

              ** [sql-param FileName] [sql-param FootNote] [sql-param
                 PartNumber] [sql-param NomHoleDia] [sql-param
            PanelThicknessMin] [sql-param PanelThicknessMax] [sql-param
              ProngLengthCRefMin] [sql-pa.....................................
.......................................................am ProngLengthCRefMax]
               [sql-param HeadStyle] [sql-param HeadDiaD] [sql-param
                              HeadHTE] **


This list is fairily extensive so Im assuming that the  query goes through
it just lacks the recognition of formatting tags,.. but why


quite puzzling, but Im sure that there is some
logical answer to this out there somewhere,
-Thanks Guys
Ill keep working on it

--Korey