Proper SQL usually uses just "or"
<cfquery name="q">
select from user
where status == "1" or status == "2"
</cfquery>
Try that.
Derek
On Jul 11, 2010, at 7:58 AM, chrille wrote:
I'm running into the wall here trying to use the || operator when
querying the GAE datastore using OBD.
The code I'm trying is:
<cfquery name="q">
select from user
where status == "1" || status == "2"
</cfquery>
The error I keep getting is "unsupported operator: ||", although the
syntax seems valid to me. Any thoughts?
/Christian
--
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
