Re: why not true when testing for equality with a null query
Re: why not true when testing for equality with a null query
- Subject: Re: why not true when testing for equality with a null query
- From: Chuck Hill <email@hidden>
- Date: Thu, 7 Dec 2006 09:46:56 -0800
What does the generated SQL look like?
I don't use display groups, so I don't know. You might want to try
setting EOKeyValueCoding.NullValue in place of the null.
Chuck
On Dec 7, 2006, at 9:32 AM, Baiss Eric Magnusson wrote:
Wouldn't the following fetch the record if I don't set any value
for the 3 <$> variables, and the record in the DB has <null> for
the 3 fields?
((areaID = $areaID) or (stateID = $stateID) or (groupID = $groupID)
or ((areaID = stateID) and (areaID = groupID)))
Do I have to set the bindings if the variable is null? Because I
do: ( thus not setting the bindings for the $areaID)
public WODisplayGroup groups;
if ( curArea != null )
groups.queryBindings().setObjectForKey( curArea.areaID(), "areaID");
etc.
----
Baiss Eric Magnusson
<http://www.Track-Your-Finances.com>
<http://www.CascadeWebDesign.com>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net
This email sent to email@hidden
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden