So, it looks like "||" is supported, but "==" is not outlined in the link previously provided:

http://code.google.com/appengine/docs/python/datastore/gqlreference.html

So, in pure SQL, you would typically use the following:

       <cfquery name="q">
        select from user
        where status = 1 or status = 2
        </cfquery>

If status is a text field of some sort, you would not use double quotes, but rather single, like the following:

       <cfquery name="q">
        select from user
        where status = '1' or status = '2'
        </cfquery>

Admittedly, I know minimal about GAE at this point, but do have a background in SQL. Do either of those work?

Derek





On Jul 12, 2010, at 1:49 PM, Matthew Woodward wrote:

On Mon, Jul 12, 2010 at 9:49 AM, Steve Of LA <[email protected]> wrote:
My cursory reading says that OR is not supported.

Pretty sure that's correct.

--
Matthew Woodward
[email protected]
http://blog.mattwoodward.com
identi.ca / Twitter: @mpwoodward

Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html

--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
online manual: http://www.openbluedragon.org/manual/

mailing list - http://groups.google.com/group/openbd?hl=en

--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/   http://twitter.com/OpenBlueDragon
online manual: http://www.openbluedragon.org/manual/

mailing list - http://groups.google.com/group/openbd?hl=en

Reply via email to