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


Recent Events
  • 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.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


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?

arijdatatable problem
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: arijdatatable problem
#44107
arijdatatable problem 4 Years, 1 Month ago Karma: 0
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
The administrator has disabled public write access.
 
#44109
Re:arijdatatable problem 4 Years, 1 Month ago Karma: 666
Hello,

Could you specify what SQL query do you use?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#44183
Re:arijdatatable problem 4 Years, 1 Month ago Karma: 0
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
The administrator has disabled public write access.
 
#44198
Re:arijdatatable problem 4 Years, 1 Month ago Karma: 666
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
The administrator has disabled public write access.
 
#44214
Re:arijdatatable problem 4 Years, 1 Month ago Karma: 0
hi,

thank you so much.

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

tq
The administrator has disabled public write access.
 
#44215
Re:arijdatatable problem 4 Years, 1 Month ago Karma: 666
BTW, it is not the extension issue, this was the problem with SQL query.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1