Jump to content

Leaderboard


Popular Content

Showing most liked content on 04/21/2017 in all areas

  1. 1 point
    A couple of things could be the issue: - SQL queries are case sensitive whereas native FM finds are not case sensitive. So if the _id_assigment is not numeric that can cause a discrepancy. - if you use PSoS to do the query but the user has not committed the record yet then server does not know about it and will return the results minus the user's record. So always do a commit before the SQL query.
  2. 1 point
    Have you considered it might be your data that's the issue? Or the $_id_assignment variable? I'd recommend simplifying the query so you can run some tests in the data viewer and/or in a test script. In said script, I'd create the query in a variable (e.g., $query) so I can see it in the data viewer.
This leaderboard is set to Los Angeles/GMT-07:00
×

Important Information

By using this site, you agree to our Terms of Use.