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

Stefan Hornburg Racke racke at linuxia.de
Fri Apr 5 10:24:00 UTC 2002


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)



More information about the interchange-i18n mailing list