Announcement

Collapse
No announcement yet.

Refined Search problem

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Refined Search problem

    Hello,
    I did a grid and I added the Refined Search on left side.
    I got some problems when activate filters so I did run the application on debug mode.

    1st QUESTION

    Looking on SQL related to Refined Search, it seems a bit strange that after WHERE conditions are doubled .
    The SELECT is absolutly normal:

    SELECT sc_concat(CustomerID, CompanyName)
    FROM customers
    WHERE CustomerID = '{CustomerID01}'
    ORDER BY CustomerID, CompanyName

    On debug I find

    (pdo-mysql): select CustomerID, CompanyName from customers where CustomerID = 'agcg' and CustomerID = 'agcg' order by CompanyName


    Please have a look to image

    2nd QUESTION

    Did anybody have problems using Maria DB ?
    The same application under Maria DB do not work , under mySQL yes .
    Is there a possible meaning ?
    Attached Files
Working...
X