Hello again,

I think width do not work when I combine fields in a query. Is this possible or whats the problem?

{arijdatatable bPaginate="true}{arisqltable width="100%"}
{arisqltablecolumns}
{arisqltablecolumn id="Produkt" alias="Produkt" width="50%"}
{/arisqltablecolumns}
{arisqltablequery}
SELECT
CONCAT('<b>',C.BEZEICH,' ',B.BEZEICH,'</b> ',B.ZUSATZBEZ) AS Produkt,
CONCAT(DATE_FORMAT(A.GILTVON, '%d.%m'),' - ',DATE_FORMAT(A.GILTBIS, '%d.%m.%y')) AS Zeitraum,
A.PREIS AS Preis,
CONCAT(B.MENGE,' ',F.BEZEICHKURZ) AS Einheit,

This should work. ARI JDataTable calculates absolute values for column width and sets them as appropriate.

Example:

{arijdatatable bPaginate="true"}
{arisqltable width="100%"}
{arisqltablecolumns}
{arisqltablecolumn id="ID" alias="ID" width="50%"}
{arisqltablecolumn id="TITLE" alias="TITLE" width="50%"}
{/arisqltablecolumns}
{arisqltablequery}
SELECT id AS ID,title AS TITLE
FROM #__modules
{/arisqltablequery}
{/arisqltable}
{/arijdatatable}

Regards,
ARI Soft

Hi, you wrote me the same example as I wrote you that it does not work. Please have a look on my code example, I tried it and it do not work believe me. You can see the result of this query on www.aktionsfinder.at/aktionsfinder/getraenke.html

regards Michael

We cannot see any table using URL you provided. Could you please point us to the page where we can see the issue.

Regards,
ARI Soft

Hi, sorry this is the right URL:

www.aktionsfinder.at/aktionsfinder/baeckerei.html

And this is behind:
arijdatatable bPaginate="true}{arisqltable width="100%"}
{arisqltablecolumns}
{arisqltablecolumn id="Produkt" alias="Produkt" width="50%"}
{/arisqltablecolumns}
{arisqltablequery}
SELECT
CONCAT('<b>',C.BEZEICH,' ',B.BEZEICH,'</b> ',B.ZUSATZBEZ) AS Produkt,
CONCAT(DATE_FORMAT(A.GILTVON, '%d.%m'),' - ',DATE_FORMAT(A.GILTBIS, '%d.%m.%y')) AS Zeitraum,
A.PREIS AS Preis,
CONCAT(B.MENGE,' ',F.BEZEICHKURZ) AS Einheit,
CONCAT(A.VERGLPREIS,' je ',G.BEZEICHKURZ) AS Vergleich,
H.BEZEICHKURZ AS Min,
D.Nachname AS Markt
FROM ......

Michl

The problem on this page is NOT is ARI JDataTable plugin. The origin of the issue is too much data that is displayed in narrow space.

You can remove {arijdatatable bPaginate="true} from this article and have a look at resulting table - all data cannot fit into available space even having appropriate percentage is set up.

Regards,
ARI Soft