When creating a custom query to use a built in geospatial function in MySQL Wappler is adding slashes to escape the quotes within the function call. This breaks the function. Is there a way to prevent this?
What was your original query? Maybe the quotes are just in the notification message only
The original query was the same, without the extra slashes escaping the apostrophes. If I take the query and put into MySQL directly it works.
Can you paste your query here?
insert into `location` (`dist` , `point`) values ('10', ST_GeomFromText('Point(36.08608987059102 -115.15872794802095)'))
So is the query working when you actually run your server action and is this error message appearing only when you try to test it within Wappler?
Yes it runs correctly.
As you can see from the original error screen shot Wappler adds a \ to escape the ’ within the ST_Geomfromtext function. This causes the error. Those \ are not in the original function I entered in the custom query.