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?

ARI Datatable - percent signs
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: ARI Datatable - percent signs
#66475
ARI Datatable - percent signs 3 Years, 11 Months ago Karma: 0
Hi, I have some problem with database queries. I have a Data Table module with SQL queries for example:

SELECT * FROM tbl WHERE value LIKE {$REQUEST:val|empty:''}

Param value is sending from the text input form. The problem is, when I try to use percent sign, for example %123456789, then ARI Data converted it to 'f34567890' and sended to DB query:

SELECT * FROM tbl WHERE value like 'f34567890'

How to send requests like '%2222' '22222%' '222%222' etc ?


ps. i use ARI Smart Content Datable
The administrator has disabled public write access.
 
Go to topPage: 1