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?

Query with {$UserId} don't work
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Query with {$UserId} don't work
#26234
Query with {$UserId} don't work 12 Years, 1 Month ago Karma: 0
Hi,
I'm stucked by trying to filter data from the logged user. The following code (as a simple example) is beeing used and does not work. But when changing {$UserId} to i.e. 42 it is ok! What is wrong???

Code:

{arisqltable}
{arisqltablequery}
SELECT *
FROM #__users
WHERE id = {$UserId}
{/arisqltablequery}
{/arisqltable}



I'm running Joomla 2.5.2

Thanks for helping!
mo
Last Edit: 2012/03/12 15:34 By mole.
The administrator has disabled public write access.
 
#26235
Re:Query with {$UserId} don't work 12 Years, 1 Month ago Karma: 748
Hello,

It is possible to use {$UserId} variable in "ARI Data Tables" extension, not in "ARI Smart Content" (provided code is for "ARI Smart Content").

Regards,
ARI Soft
The administrator has disabled public write access.
 
#26236
Re:Query with {$UserId} don't work 12 Years, 1 Month ago Karma: 0
But I have bought ARI Smart Content: DataTable Pack v. 1.8.1. (have a look in my profile user = mole) Is it not the same as ARI Data Tables. If so where is the major difference?
The administrator has disabled public write access.
 
#26237
Re:Query with {$UserId} don't work 12 Years, 1 Month ago Karma: 748
These are two different extensions. "ARI Data Tables" is a Joomla! module. See it in action here.

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