Announcement

Collapse
No announcement yet.

Dynamic search and sc_select_where macro don't work together

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

  • Dynamic search and sc_select_where macro don't work together

    Doing dynamic search and using macro sc_select_where(add) at the same time is not possible. An error comes up when search is applied. Look at the attached image.

    dynamic_search.png

    It seems that the 'where clause' is not well formed in the query.

    Tested in Google Chrome.
    Last edited by mister_doctor; 10-02-2015, 10:01 AM.

  • #2
    I solved this by adding a where clause in the SQL Statement like this: where 1=1, this way in the sc_select_where(add) macro I just add "AND conditions"

    Comment

    Working...
    X