[ic] [query] in a [loop]

[Xavier GILLET]

Merci beaucoup Ton.
You code is the good one !!

Xavier.


----- Original Message -----
From: "Ton Verhagen" <ton@verhagen.net>
To: <interchange-users@icdevgroup.org>
Sent: Tuesday, May 06, 2003 2:45 PM
Subject: Re: [ic] [query] in a [loop]


> Quoting Xavier GILLET <xavier.gillet.perso@wanadoo.fr>
> > > > > > Hello,
> > > > > >
> > > > > > Did someone tried something like this ?
> > > > > >
> > > > > [loop prefix=fichiers arg="a01b02c01 a01b02c02 a01b02c03"]
> > > > > [set foo][fichiers-code][/set]
> > > > >  [query
> > > > >      type=list
> > > > >      ml=1000
> > > > >      sql="select actual_status from [scratch foo] where
> > > > >             posted_by = '[data session username]'
> > > > >             and
> > > > >             initial_status = 'confirmee'
> > > > >          "]
> > > > >
> > > > > > It seems not possible to execute a [query] in a [loop].
> > > > > > Any idea ??
> > > > >
> > > > > Try with a scratch...
> > > > >
> > > > > Rene
> > > >
> > > >
> > > > It seems the problem come from the [query] inside the [loop].
> > > > I tried to set a [scratch] value, but it's the same.
> > >
> > > Firstly, I think it should be:
> > >
> > >   [loop prefix=fichiers list="a01b02c01 a01b02c02 a01b02c03"]
> > >
> > > Secondly, [set] does not interpolate. Since you are only using the
scratch
> > > in the page, I suggest you use [tmp]:
> > >
> > > [loop prefix=fichiers list="a01b02c01 a01b02c02 a01b02c03"]
> > >  [tmp foo][fichiers-code][/tmp]
> > >   [query
> > >       type=list
> > >       ml=1000
> > >       sql="select actual_status from [scratch foo] where
> > >              posted_by = '[data session username]'
> > >              and
> > >              initial_status = 'confirmee'
> > >           "]
> > >
> >
> >Still not working.
> >
> >[loop prefix=fichiers list="a01b02c01 a01b02c02 a01b02c03"]
> >  [seti foo][fichiers-code][/seti]
> >[scratch foo]<br>
> >   [query
> >       type=list
> >       ml=1000
> >       sql="select actual_status from [scratch foo] where
> >              posted_by = '[data session username]'
> >              and
> >              initial_status = 'confirmee'
> >           "]
> >   [list]
> >
> >   [/list]
> >[/query]
> >[/loop]
> >
> >This loop return just this :
> >[fichiers-code]
> >
> >The code is supposed to return :
> >a01b02c01
> >a01b02c02
> >a01b02c03
>
>
> Xavier, I think that you should try the following construct (worked for
me):
>
> [loop prefix=fichiers list=""a01b02c01 a01b02c02 a01b02c03""]
>
> [fichiers-code]<br>
>
>    [query
>        prefix=sql
>        type=list
>        ml=1000
>        sql="select actual_status from [fichiers-code] where
>                posted_by = '[data session username]'
>                and
>                initial_status = 'confirmee'
>            "]
>    [sql-list]
>      line: [sql-increment] -- [sql-param actual_status]
>    [/sql-list]
>
> [/query]
> [/loop]
>
> I assume that a01b02c01 a01b02c02 a01b02c03 are valid tables.
>
> Please note the 'prefix' in the query tag.
>
> Good luck!
>
>
> Best regards,
>
> Ton
>
> --
> Alamerce Nederland --- Cornerstone of eBusiness
> Phone +31-40-2374381    info@alamerce.nl    http://www.alamerce.nl
>
> eCommerce Solutions -- Consulting -- Website & Interchange Hosting
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>