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


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

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


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, 8 Months 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, 8 Months ago Karma: 760
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, 8 Months 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, 8 Months ago Karma: 760
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