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
#62979
pass data from ari data tables to another 6 Years, 7 Months ago Karma: 0
Hi,

as you have explained in a very good way I've used Format field in Column settings to link to another page passing a parameter,too, in this way:

<a href="PAGE_TO_LINK/{$value}">{$value}</a>

now I would like to use the $value in a query of the PAGE_TO_LINK (ari data table page):

in which way could I do?

Thanks a lot for your help
The administrator has disabled public write access.
 
#62981
Re:pass data from ari data tables to another 6 Years, 7 Months ago Karma: 760
Hello,

Could you describe in more details what you want to achieve?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#62982
Re:pass data from ari data tables to another 6 Years, 7 Months ago Karma: 0
Absolutely

I have two ari data tables

In the first i choose a Field That is the key of the second data table, during the link I pass the Field in this way:
<a href="PAGE_TO_LINK/{$value}">{$value}</a>
After That i want to use the $value to select records from second data table i this way, select a from table b where key= $value

I dont know what to do
The administrator has disabled public write access.
 
#62983
Re:pass data from ari data tables to another 6 Years, 7 Months ago Karma: 760
The parameter can be added to the link as GET variable. It will look like:

Code:


<a href="PAGE_TO_LINK?some_key={$value|url_encode}">{$value}</a>



and then use {$REQUEST:some_key} predefined variable in WHERE clause of SQL query in the second table. For example:

Code:


SELECT
  id,
  title
FROM
  some_table
WHERE
  id = {$REQUEST:some_key|empty:''}



Regards,
ARI Soft
The administrator has disabled public write access.
 
#62984
Re:pass data from ari data tables to another 6 Years, 7 Months ago Karma: 0
Great!

It works perfectly!

Thank you so much for your help, you're very very professional
The administrator has disabled public write access.
 
#63007
Re:pass data from ari data tables to another 6 Years, 7 Months ago Karma: 0
I'm really sorry to bother you again,
but I've a little problem that I can'solve by myself:

following your precise instruction I've built this query in ari data tables:

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

but it doesn't work

what do I wrong?

thanks a lot for your attention and your help
The administrator has disabled public write access.
 
Go to topPage: 12