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

Korey G. interchange-users@interchange.redhat.com
Tue Dec 4 12:50:01 2001


I have it set like so right now:
[query sql="SELECT * from table001  "
         type=list
         list=1
         more=1
         ml=1000]


                 [list]
                         [perl]
                         $Tag->loop(
                                 {
                                  list => __TABLE_001__,
                                 },

                                 for(@list) {q{[sql-param $list]}}


                         )
                         [/perl]


                 [/list]

[/query]
still not having any luck
this is what it says in my log
Safe: syntax error at (eval 8235) line 7, near ",
 >
 >                               for"
 >
 >
 >                       $Tag->loop(
 >                               {
 >                                list => FileName, FootNote, PartNumber, 
NomHoleDia, PanelThicknessMin, PanelThicknessMax, ProngLengthCRefMin, 
ProngLengthCRefMax, HeadStyle, HeadDiaD, HeadHTE ,
 >                               },
 >
 >                               for(@list) {q{[sql-param $list]}}
 >
 >
 >                       )
theres a logical problem here that Im just blindly overseeing, any suggestions,

-Korey



At 09:17 12/4/01 -0800, you wrote:
> > At 08:11 12/4/01 -0800, you wrote:
> > > > 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]}
> > >
> > >Maybe...
> > >
> > >for(@list) {q{[sql-param $list]}}
> > >
> > >...just a thought.
> > whats the q in q{[sql.... mean
>
>"q" = "quote", I believe.  In Interchange language, it means "make them
>ther's ic tag thingies work in them ther's [calc] thingies".  (I feel a
>correction coming already...)  :-)
>
>Dan Browning
>Kavod Technologies
>
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users