A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Take Control of Upgrading to Yosemite
Take Control of Automating Your Mac
this week in the
EJB Certification (SCBCD/OCPJBCD)
Select Clause Returning CMR Field
Joined: Jan 28, 2004
Jul 08, 2004 13:58:00
HFEJB P406, in the box it says: You can't use dot notation to return a CMR field e.g.
SELECT m.director FROM...
is invalid if 'director' is CMR field.
But, I went thru Richard Monson-Haefel's
book P237 where there is an example like this:
SELECT c.creditCard.creditCompany.address FROM Customer As c
'creditCard', 'creditCompany' and 'address' are all related CMR fields.
And the book says we can put CMR field in SELECT clause if it returns a single type.
So who is correct?
Joined: Aug 26, 2001
Jul 09, 2004 00:18:00
You have already started a topic with this question, why not resurrect it instead of creating a new one?
I'm closing this thread. You can continue this discussion at:
Thank you for your comprehension
[ July 09, 2004: Message edited by: Valentin Crettaz ]
SCJP 5, SCJD, SCBCD, SCWCD, SCDJWS, IBM XML
My Linked In
subject: Select Clause Returning CMR Field
EJB QL - returning collection
Last Minute Beta Tips
HF-EJB: doubt regarding EJB-QL
HFEJB 429 Q13
HFEJB P406 - Why EJBQL SELECT Cant Return Single Valued CMR field?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014