I have a query I had to rewrite due to client moving servers. My function that worked fine on mysql did not work on MAriaDB which was what new server had. Thanks goodness for custom queries that were added to Wappler recently.
My custom query calculates distances between location selected on a page and the employers display in the results sorted by nearest to selected location to furthest.
Everything works fine on my local server that uses the live db, but the query does not “get” the lat and long values to make a calculation on the live server. I have checked that needed files are uploaded, but somewhere something is weirdly wrong. This site started on app connect/server connect on Dreamweaver and made the migration to Wappler for updates over the past 2+ years.
here is the page in question with the params already filled in the url:
it is used with South African locations.
Last updated: