Forum Discussion

chrisbodman's avatar
chrisbodman
New Contributor II
5 years ago

Not Comparable Objects: BigInteger 350930 and Integer 350930

I’ve done a join to 5 tables. All works fine in validation. No errors at all. If I use a specific value in the where clause in the 4 SQL Selects, it’ll run fine. If I give it a parameter (instead of a hardcoded value). I get the error “Not Comparable Objects: BigInteger 350930 and Integer 350930”. They’re exactly the same field type in the DB. If I replace $PropertyId with 350930, it’ll work. It’s getting the values, as they’re shown in the error. I’ve tried casting them both to the same time (Integer, Float, and String), and then I get the error that they’re not ascending, if I change to ascending, I get an error saying they’re not descending, etc etc.