DMXzone Server Connect Support Product Page

Solved

Filter Comparisons Not Working

Reported 21 Jun 2016 16:02:38
2
have this problem
21 Jun 2016 16:02:38 Keith Mears posted:
I am having a problem getting any return when setting up a filter with a comparison that uses the "Contains", "Starts With", etc,. I have tried many variables and on different tables as well and I fell there is something really odd going on. All symbol comparison (=, <, >, etc) work fine getting the results expected, but any word ones ("Contains", "Starts with", etc) fail to get a return. This makes it very difficult to get the results I need, especially when setting up a search.

So far no answers as to what may be the problem.

Regards

Keith

Replies

Replied 27 Jun 2016 11:44:16
27 Jun 2016 11:44:16 Teodor Kuduschiev replied:
Hello Keith,
I am not really sure i understand your issue. Which exact filter conditions are not working? I just checked contains, strats with, between and they all work just fine.
Replied 28 Jun 2016 09:04:47
28 Jun 2016 09:04:47 Keith Mears replied:
Hi Teodor

I have been using the Server Connect for some time with no problem but now I am unable to get the filter to work. To show my problem I have set up a page with the server Connect, the dataBindings extension and the dreamweaver native recordset to show a nil result for Server Connect but accurate results from Databindings and native dreamweaver server action. The lint to the page is here

I was going to attach the images of the settings but the link above does not work, I have added them to the page linked above so you can see what I am doing. This is so odd I keep questioning what I am doing hence why I have used a new hosting with just this page on it, but I am lost with this.

I would appreciate some help. I have removed the extension and reinstalled it with no change.

Regards

Keith
Replied 18 Jul 2016 14:12:39
18 Jul 2016 14:12:39 Patrick Blanc replied:
I have the same problem
After a lot of test, ony = works
all the rest doesn t
Replied 18 Jul 2016 14:23:31
18 Jul 2016 14:23:31 Teodor Kuduschiev replied:
Hello Patrick,
After a conversation in our live chat support, it turned out that Keith had old files left on the server. Make sure to reapply your server action and manually upload all of the files to the server.
Replied 19 Jul 2016 09:49:46
19 Jul 2016 09:49:46 Patrick Blanc replied:
Hello Teodor
Wich file ? cause there is a lot...if it s server connect, all is recently upload
i found the solution by changing php file like this and it s working

"wheres": [
{
"table": "photos_patrick",
"column": "serie",
"bool": "and",
"operator": "like",
"value": "%{{$_GET.serie}}%",
"type": "text"
}
Do you have a better idea?
And have you find a solution about my problem with css galery 2 with dynamic images and problem with lightbox?
Replied 19 Jul 2016 09:52:27
19 Jul 2016 09:52:27 Teodor Kuduschiev replied:
Do not change the code generated by the extension as it will cause more problems.
The files, located in dmxconnectLib folder are most probably old versions. Install the latest versions, remove dmxconnectLib folder, then save your action file and it will generate newer ones.
Replied 19 Jul 2016 10:34:16
19 Jul 2016 10:34:16 Patrick Blanc replied:
Thank you
You re right
it s working now
And about css gallery lightboox with dynamics images?
Replied 19 Jul 2016 10:35:44
19 Jul 2016 10:35:44 Teodor Kuduschiev replied:
You are welcome!
AS for the lightbox - this will require an update, i will let you know as soon as i have news about the update.
Replied 19 Jul 2016 10:42:07
19 Jul 2016 10:42:07 Patrick Blanc replied:
Thank you

Reply to this topic