[interchange-i18n] Re: [ic] getting data on categoryvertical

guslist at kerntec.net guslist at kerntec.net
Fri Apr 5 11:24:00 UTC 2002


Hi,

I´ve tryed your code but I only get the same error:
> [sql-param code], [sql-param name]

I´ve tryed to change your code a "littlebit" but whith no success.
Any help ?

Thank´s again,
Gus

----- Original Message -----
From: "Stefan Hornburg (Racke)" <racke at linuxia.de>
To: <interchange-users at interchange.redhat.com>
Cc: <interchange-i18n at interchange.redhat.com>
Sent: Friday, April 05, 2002 12:21 PM
Subject: Re: [ic] getting data on categoryvertical


> guslist at kerntec.net writes:
>
> > Hello IC users,
> >
> > I´m trying to change the table to be read at category_vertical. This is
for
> > my locale settings on my store.
> > I what to select which table to use depending on the lng that the user
is
> > using.
> > Ex: I´ve created tables: area_pt_BR, cat_pt_BR and products_pt_BR.
> >
> > When creating the left menu, I what to filter this.
> > I´ve tryed to change the table using loop at the original code but I
can´t
> > find where I can set the table to get data from.
> >
> > I´ve tryed the to substitute the loop to sql commands where I can
manipulate
> > the selects better. But, nither this way it works. I´ve tryed this code:
> > --
> > [query
> > prefix=box
> > type="list"
> > list_prefix="boxlist"
> > sql=|
> > select
> > *
> > from area, cat
> > order by area.sort
> > |
> > ]
> > [sql-param code], [sql-param name]<BR>
>
> Try this:
>
> [if scratch mv_locale]
> [tmp query]
> select
> *
> from area_[scratch mv_locale], cat_[scratch mv_locale]
> order by area_[scratch mv_locale].sort
> [/tmp]
> [else]
> [tmp query]
> select
> *
> from area, cat
> order by area.sort
> [/tmp]
> [/else]
> [/if]
>
> [query
> prefix=box
> type="list"
> list_prefix="boxlist"
> sql="[scratch query]"
> ]
> [sql-param code], [sql-param name]<BR>
>
> Ciao
>         Racke
>
> --
> Think of it !
>
> For projects and other business stuff please refer to COBOLT NetServices
> (URL: http://www.cobolt.net; Email: info at cobolt.net; Phone:
0041-1-3884400)
> _______________________________________________
> interchange-users mailing list
> interchange-users at interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>




More information about the interchange-i18n mailing list