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


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


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?

pass data from ari data tables to another
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: pass data from ari data tables to another
#63008
Re:pass data from ari data tables to another 6 Years, 7 Months ago Karma: 0
I try to explain in a better way:

I've build a serch page following your indications and it works well.
Unfortuntely teh search works in a table with 200.000 records and to load everything is very hard.

So that I've passed a parameter to search to ari data table changing the query from this
select
denominazione,
cod_fiscale,
num_avviso,
importo
from
cb6crm_contribuenti
where
denominazione ={$REQUEST:sSearch|empty:''}

to that:

select
denominazione,
cod_fiscale,
num_avviso,
importo
from
cb6crm_contribuenti
where
denominazione like {$REQUEST:sSearch%|empty:''}

but I probably make a mistake with the sysntax: Could you pleasae help me?
The administrator has disabled public write access.
 
#63009
Re:pass data from ari data tables to another 6 Years, 7 Months ago Karma: 0
I fondi the Solutions by myself

select
denominazione,
cod_fiscale,
num_avviso,
importo
from
cb6crm_contribuenti
where
denominazione like concat ({$REQUEST:sSearch},'%')

Now it works perfectly
The administrator has disabled public write access.
 
Go to topPage: 12