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


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


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?

Variables in ARI Data Tables - SQL query
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Variables in ARI Data Tables - SQL query
#25729
Variables in ARI Data Tables - SQL query 5 Years, 7 Months ago Karma: 0
Is it possible to pass a variable to a Ari Data Tables module?


Instead of creating 101 different Data Table Modules with small SQL Variations : What I want to do is pass a variable to the Module on a page.

Variables: UserID, UserType, etc... Is not suitable but a great feature.
The administrator has disabled public write access.
 
#25730
Re:Variables in ARI Data Tables - SQL query 5 Years, 7 Months ago Karma: 666
Hello,

It is possible to use a request variables in a SQL query. For example if necessary to use "var1" request variable, use the next code {$REQUEST:var1}

Regards,
ARI Soft
The administrator has disabled public write access.
 
#25731
Re:Variables in ARI Data Tables - SQL query 5 Years, 7 Months ago Karma: 0
Example:
{aridatatables moduleId="93" lenderid="2"}
on another page:
{aridatatables moduleId="93" lenderid="3"}

Then LenderID is passed to SQL Query.
The administrator has disabled public write access.
 
#25732
Re:Variables in ARI Data Tables - SQL query 5 Years, 7 Months ago Karma: 0
wow, your fast at replying. Its great to know..

So in SQL query I can put {$REQUEST:var1}
Where do i set var1? in the URI or in module code?
The administrator has disabled public write access.
 
#25733
Re:Variables in ARI Data Tables - SQL query 5 Years, 7 Months ago Karma: 666
It accepts POST and GET request variables.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#25745
Re:Variables in ARI Data Tables - SQL query 5 Years, 7 Months ago Karma: 0
That is great and will save me some time, its no good for SEO though.

I can display the table using GET for a specific category, but not able to put Category Name as the "Article Title".

Is it possible to pass variable via like my example? or something simular?
{aridatatables moduleId="93" lenderid="2"}

I THINK - this says its possible but not sure.
Last Edit: 2012/03/01 08:23 By hosker4u.
The administrator has disabled public write access.
 
Go to topPage: 12