Hey all! I am using mssql with orion, and my problem is that my finders dont find null values. The problem is that orion just generates a whereclause "where x = null", and in tsql "no instance of null equals another instance of null", so the correct where clause would be "where x is null". I now write my queries all as "where $1 = $field or ($1 is null and $field is null) as a workaround, but I wonder if orion has some kind of special null handling. regarz chris
- RE: handling null values in finders Christoph Sturm
- RE: handling null values in finders Simon Salykov
- Re[2]: handling null values in finders Christoph Sturm