Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

width do not work with concat
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: width do not work with concat
#783
width do not work with concat 8 Years, 11 Months ago Karma: 0
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,
The administrator has disabled public write access.
 
#788
Re:width do not work with concat 8 Years, 11 Months ago Karma: 670
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
The administrator has disabled public write access.
 
#790
Re:width do not work with concat 8 Years, 11 Months ago Karma: 0
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
The administrator has disabled public write access.
 
#791
Re:width do not work with concat 8 Years, 11 Months ago Karma: 670
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
The administrator has disabled public write access.
 
#796
Re:width do not work with concat 8 Years, 11 Months ago Karma: 0
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 administrator has disabled public write access.
 
#797
Re:width do not work with concat 8 Years, 11 Months ago Karma: 670
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
The administrator has disabled public write access.
 
Go to topPage: 12