Re: Passing variables to a [%.. %]

[% query = 'SELECT * FROM page_tb WHERE  (status  = 2 AND page_code = "
_ data.page_name + '" AND sitename = "' _ data.sitename _" ) ORDER BY
sitename' %]

[% FOREACH link = DBI.query( query ) %]

              [% site      = link.sitename        %]
                [% PageName  = link.view_name %]
                [% Record_id = link.record_id  %]
                [% body      = link.body %]
      [% END %]

that should work for you. Please not, though, the query should really be
executed in your Perl code and only the resulting list passed in to the
template..

cheers,

J

On Mon, Jan 16, 2012 at 4:58 AM, <[email protected]> wrote:

> > On 15 Jan 2012, at 06:38, "[email protected]"
> > <[email protected]> wrote:
> >
> >> Hi
> >>
> >>
> >>      [%# embed(data.page_top_view,['-PAGE_TITLE','$PageName',]) %]
> >>    [% embed(data.page_top_view,['-PAGE_TITLE',[%link.viewname%]) %]
> >
> > I don't think you need [% ... %] around link.viewname do you?
> >
> >
> You are right this is because of the limitation of ttml to not be able to
> nest[% ... %]
>
> I did manage to get the above code to work by changing the ' to ".
>
> Passing variblles into [% ... %] is a on going problem for me.
>
> a keyone is
>
> [% pagecode = data.page_name %] picked up from the url
> [% sitename = data.sitename %]
>  [% FOREACH link = DBI.query("SELECT * FROM page_tb
>                                  WHERE  (status  = 2 AND
>                                         page_code = "$pagecode" AND
>                                         sitename = "$sitename" )
>                                  ORDER BY sitename
>                                  ")%]
>               [% site      = link.sitename        %]
>                 [% PageName  = link.view_name %]
>                 [% Record_id = link.record_id  %]
>                 [% body      = link.body %]
>       [% END %]
> This dose not work. How can I do this? I suppose I could drop to [%
> RAWPerl%]. Any suggestions would be appreciated.
>
> Thanks
> shanta
>
>
> _______________________________________________
> templates mailing list
> [email protected]
> http://mail.template-toolkit.org/mailman/listinfo/templates
>

_______________________________________________
templates mailing list
[email protected]
http://mail.template-toolkit.org/mailman/listinfo/templates