Hello everybody, I’m performing a query on my tableView to show the names of the regions of Italy … I have no problem to show results for nearly all regions but it seems there are problems for regions that have in their character name special such as “Valle d’Aosta” … the character “d '” returns me an error
04/03/2016 11: 57: 06,994 Unistit [4566: 1,292,755] Valle d’Aosta
04/03/2016 11: 57: 07,009 Unistit [4566: 1,292,755] VALUE (null)
04/03/2016 11: 57: 07,582 Unistit [4566: 1,292,755] Server reported an error: FAULT = ‘1017’ [Invalid where clause] <Invalid where clause>
Sergey Hello, thanks for your support … Your advice is correct and it works perfectly, but the problem is that I do not only need “Valle d’Aosta” but also of other regions and entering the whereClause in your way gives me only one query for the Aosta valley and not for any other … I made other attempts but it seems that I can not find a solution … any other ideas ???
Before you run a query, you need to check if the string contains any ’ characters. if it does, then you need to make sure that in the query you escape ’ with another '.
Guys forgive me, probably so tired that I can not understand even the little things … forgive me … but I just can not … anyway this is my query, you can show me how to modify it to get my results?
I did not understand how I close this post without having resolved now … I also wrong to close the post by mistake. However nothing … I tried in every way and I continue always ricervere the same mistake
Server reported an error: FAULT = ‘1017’ [Invalid where clause] <Invalid where clause>
Maybe you were right Mark, it’s probably a Bug! I currently-stop app development for this thing … amazing …
First, you replace any single ’ with ‘’ (I suppose Objective-C has some “replace” function). This won’t change plain strings, but will correct the ones that contain ’ symbol.
Second, in your where clause, use ` symbol instead of ’ on the leftmost and rightmost places.
Here are some examples of what you need to send as a result:
the problem is that my where clause is not static but changes according to the tableView cell that you selected by returning the value of NSString that I need … anyway I solved with a simple IF dividing the query and its where clause
Hello Guys are always me … I explained why this quesry does not work ?? I always returns the same mistake that I had before, but I had changed all the code according to your advice … the error is:
12/20/2016 19: 13: 09,285 UNISTit [20630: 5124305] Server reported an error: FAULT = ‘1017’ [Invalid where clause: Abruzzo] <Invalid where clause: Abruzzo>
Tell me where I’m wrong because I’m going crazy … Until a few months ago everything worked …