hi,

i'm using arijdatable to display data from mysql database.

however, for the field with type Longtext it won't displayed the data. is there any limitation for the plugin.

hope u can help me. tq

Hello,

Could you specify what SQL query do you use?

Regards,
ARI Soft

Here as below:

FYI, the field name=desc, is using Longtext type

{arijdatatable bLengthChange="true" asStripClasses="list_odd,list_even" iDisplayLength="20"} {arisqltable}{ariconnectionstring dbHost="localhost" dbName="db_name" dbUser="root" dbPass="dbpwd" dbType="mysqli" persistent="false"}{arisqltablecolumns}{arisqltablecolumn id="Date" alias="Date" headerClassName="head"}{arisqltablecolumn id="Desc" alias="Description" headerClassName="head"}{/arisqltablecolumns}{arisqltablequery} SELECT DATE_FORMAT(date_case,'%d-%m-%Y')AS Date,desc AS Desc FROM tbl_a {/arisqltablequery}{/arisqltable} {/arijdatatable}

Hope u can help me, tq

If you see nothing then use the following plugin code:

{arijdatatable bLengthChange="true" asStripClasses="list_odd,list_even" iDisplayLength="20"} {arisqltable}{ariconnectionstring dbHost="localhost" dbName="db_name" dbUser="root" dbPass="dbpwd" dbType="mysqli" persistent="false"}{arisqltablecolumns}{arisqltablecolumn id="Date" alias="Date" headerClassName="head"}{arisqltablecolumn id="Desc" alias="Description" headerClassName="head"}{/arisqltablecolumns}{arisqltablequery} SELECT DATE_FORMAT(date_case,'%d-%m-%Y')AS Date,`desc` AS `Desc` FROM tbl_a {/arisqltablequery}{/arisqltable} {/arijdatatable}

If you see 'Date' column and don't see 'Description' column, send SQL dump of your table by email so we can try to reproduce the problem on our test server.

Regards,
ARI Soft

hi,

thank you so much.

it works if change 'desc' AS Desc with desc AS 'Desc'

tq

BTW, it is not the extension issue, this was the problem with SQL query.

Regards,
ARI Soft