Re: Incorrect Fetch Syntax? Next Record function?
Re: Incorrect Fetch Syntax? Next Record function?
- Subject: Re: Incorrect Fetch Syntax? Next Record function?
- From: Francis Labrie <email@hidden>
- Date: Thu, 7 Oct 2004 11:16:14 -0400
Hi Jeremy,
Jeremy Matthews write:
I have the following search in my App, and things are interesting. I
can search by first name or last name separately and the search works
fine. However, when I attempt to use them in conjunction I find no
data. My Fetch is setup in EOM as:
((firstName like $firstName) or (lastName like $lastName) or
((firstName like $firstName) and (lastName like $lastName)))
First, you don't have to join both: if you build a the thuth table for
this, you'll find that "(firstName like $firstName) or (lastName like
$lastName)" have the same result.
About EOF result now: it's strange, indeed. Can you turn on the
debugging and check the SQL code generated?
Also, are there any good examples of a "Next Record" function by
action in WO? Since I'm not doing D2W, I'm trying to reverse-engineer
the functionality.
Using EOF, you typically work with arrays of results. So the basic way
to get the next record is to scan the array for each element.
--
Francis Labrie
Saint-Bruno-de-Montarville, Quebec, Canada
_______________________________________________
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