ARI Soft - Compound WHERE Clause in Ari Data Tables?

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

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

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

more...

2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

Compound WHERE Clause in Ari Data Tables?

(1 viewing) (1) Guest

Page: 1

TOPIC: Compound WHERE Clause in Ari Data Tables?

Forum Tools

#36232

Compound WHERE Clause in Ari Data Tables? 11 Years, 10 Months ago	Karma: 0
Hello I am using ARI Data Tables and in SQL query section I have: SELECT CompanyName, WEB FROM sheet4 WHERE City = {$REQUEST:City} AND cuisine = {$REQUEST:cuisine} AND price = {$REQUEST:price} Unfortunately, it doesn't work. Is it possible to have compound where clause such as one above? Thanking you in advance for your assistance.

tmediacom

The administrator has disabled public write access.

#36237

Re:Compound WHERE Clause in Ari Data Tables? 11 Years, 10 Months ago	Karma: 760
Could you provide a link to a page where we can see a problem? Regards, ARI Soft

admin

The administrator has disabled public write access.

#36271

Re:Compound WHERE Clause in Ari Data Tables? 11 Years, 10 Months ago	Karma: 0
Hi - Thanks for your response, the link you requested is as follows: palmsprings-mobile.com/index.php/portfolio/video-portfolio The full query in the SQL section of Data Tables is: SELECT CompanyName, City, WEB FROM sheet4 WHERE City = {$REQUEST:City} AND cuisine = {$REQUEST:cuisine} AND price = {$REQUEST:price}

tmediacom

Last Edit: 2013/01/31 00:34 By tmediacom.

The administrator has disabled public write access.

#36313

Re:Compound WHERE Clause in Ari Data Tables? 11 Years, 9 Months ago	Karma: 760
Hello, Use the following SQL query: SELECT CompanyName, City, WEB FROM sheet4 WHERE ({$REQUEST:City\|empty:''} = '' OR City = {$REQUEST:City\|empty:''}) AND ({$REQUEST:Cuisine\|empty:''} = '' OR cuisine = {$REQUEST:Cuisine\|empty:''}) AND ({$REQUEST:Price Range\|empty:''} = '' OR price = {$REQUEST:Price Range\|empty:''}) Regards, ARI Soft

admin

The administrator has disabled public write access.

Page: 1

Useful Links