Arturo, thank you for your help, you got my attention with the outer
join. I tried rewriting it with multiple outer joins and I remembered
why that didn't work. The problem is when two or more joins are valid,
only the valid ones should be required, which is what my code does.
So I'm going to wipe the slate clean and start over and hopefully I'll
be more clear this time.
I have a table I want to display. I want to filter the table based on a
username field that will not be shown in the display of said table. The
text of the filter, "joesmith" say, is in the session in a string
variable named login.
Now, in such a way that the user can not change the filter (don't want
it added to the hyperlink because once logged in the user could change
the filter to "maryjones" and see another user's records) I want to
apply said filter to table before display.
If this can be done without fighting WebObjects, I would appreciate a
hint. If this is not right, I would appreciate some feedback as to how
others may have done this sort of thing.
justin
On May 5, 2004, at 9:49 AM, Arturo Pirez wrote:
[snip]
Let's take this one as an example. Your view table is named THEFORECAST.
CASE WHEN usertable.company IS NOT NULL
THEN usertable.company = theparts.company
ELSE true
END
This looks like an outer join to me. Something like
usertable LEFT OUTER JOIN theparts using (company)
[snip]
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
