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?

ARI Datatable - percent signs
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: ARI Datatable - percent signs
#66475
ARI Datatable - percent signs 4 Years, 6 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