I am currently trying to pass a variable from a client-side(javascript)controller to server-side(APEX)controller. I'm currently using setParams() in the client-side controller to set the current user's geolocation in the server-side controller so that I can find all accounts within 50 miles of them, but I keep getting errors such as "unexpected token 'userLat'". I have been working on figuring this out all day, but to no avail so some help would be great. Thanks in advance.

Some code:


public with sharing class AccountController { public String userLat {get; set; } public String userLong {get; set; }

public static List<Account> findAll(String userLat, String userLong) {
    return [SELECT id, name, latlng__Latitude__s, latlng__Longitude__s
            FROM Account
            WHERE DISTANCE(latlng__c, GEOLOCATION(userLat, userLong), 'mi') < 50
            ORDER BY DISTANCE(latlng__c, GEOLOCATION(userLat, userLong), 'mi')
            LIMIT 5];



//where I get/set the user's location - userLat and userLong var action = component.get("c.findAll"); action.setParams({"userLat": "userLat", "userLong": "userLong"}); action.setCallback(this, function(a) { component.set("v.accounts", a.getReturnValue()); var event = $A.get("e.c:AccountsLoaded"); event.setParams({"accounts": a.getReturnValue()}); event.fire(); }); $A.enqueueAction(action); }

  • Did you forget the Bind : for the UserLat in the SOQL query. Is that even allowed? If not, try with a dynamic query – Eric Jul 27 '15 at 19:55

From what I understand you cannot use bind variables as part of the GEOLOCATION:


so you will have to do it dynamically:

String q = 'SELECT id, name, latlng__Latitude__s, latlng__Longitude__s ' +
            'FROM Account ' +
            'WHERE DISTANCE(latlng__c, GEOLOCATION(' + userLat + ',' +  userLong + '),' \'mi\') < 50 ' +
            'ORDER BY DISTANCE(latlng__c, GEOLOCATION(' + userLat + ',' +  userLong + '),' \'mi\') ' +
            'LIMIT 5';
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.