Hi

I have been puzzling already for a while how to combine the ARI sql table and ARI JtableSorter. I saw some threads which slightly touched this one but I can not get it fixed... Could you please give some sample code so I can figure it out. For example the one smart.ari-soft.com/ari-jtablesorter.html

Is it also possible to use both the plugins with an autocomplete search parameter. So if the first 3 letters of a string value are typed in, in real time the matches from a column are given. In fact just like google is doing with a search.

Many thanks in advance,

Jeroen

Hello,

1. See a sample code below please:



2. The extension doesn't support autocomplete search.

Regards,
ARI Soft

Didn't know it was that easy! Great. Only one small but...

I now have the code:
{arijtablesorter paging="true"}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="ID" alias="IDEE" width="20%" className="idg"}
{arisqltablecolumn id="NAME" alias="UserName" headerClassName="head"}
{/arisqltablecolumn}
{/arisqltablecolumns}
{arisqltablequery}
SELECT adres AS ID,postcode AS NAME FROM #__locaties
{/arisqltablequery}
{/arisqltable}
{/arijtablesorter}


1. It is not using the alias UserName. It is using just NAME. But it is using IDEE... Do you know what to do?

2. When I am using it with a table with more than 1000 rows it seems not to work. I get a white screen...

1. Could you provide an image where we can see described problem?

2. Try to increase value of "memory_limit" PHP parameter. It can be done with help PHP Settings plugin.

Regards,
ARI Soft

Great works awesome!

Thanks