Re: Creating a fetch that returns the same results as using "session.user.meetings" in WOBuilder
Re: Creating a fetch that returns the same results as using "session.user.meetings" in WOBuilder
- Subject: Re: Creating a fetch that returns the same results as using "session.user.meetings" in WOBuilder
- From: David Holt <email@hidden>
- Date: Mon, 10 Apr 2006 14:13:53 -0700
| Thanks Chuck,
Just to follow up, your code with my modification forms the SQL perfectly. Go figure.
On 7 Apr 2006, at 5:37 PM, Chuck Hill wrote: So now I have no idea why the applicationUsers accepted one ApplicationUser as the argument.
I don't either. Perhaps this was fixed and was not in the release notes or I forgot about it. Which version of WO? Which database? Can you turn on SQL logging and post what is being generated for this?
WO 5.3 MySQL v 4.0.15
Query "SELECT t0.date, t0.fk_application_id, t0.hide, t0.location, t0.meeting_ID, t0.meeting_desc, t0.meeting_time, t0.meeting_title FROM meeting t0, ApplicationUserMeeting_lookup T1, ApplicationUser T2 WHERE T2.applicationUserID = 1 AND t0.meeting_ID = T1.fk_meeting_ID AND T1.fk_applicationUserID = T2.applicationUserID" execution time: 1 result set fetch time: 2 |
_______________________________________________
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