GQL: SELECT WHERE NULL

[Alf Eaton]

I'm trying to query a datastore to find all the objects where a
particular field is empty, but
'SELECT * FROM Item WHERE field IS NULL"
produces an "Invalid GQL query string" error.

What should the syntax be for this kind of query?

[Mahmoud]

Check out this thread:
http://groups.google.com/group/google-appengine/browse_thread/thread/48888823fd3faa3b

You'll have to think of a different way to do this.

[Gadi]

you should use:
db.GqlQuery ("SELECT * FROM model WHERE property=:1",None)

None is the python Null