cd.getLocation() is not returning the Location object? This should
work, please show the code you using to access the Location.
john mcnally
Saimon Moore wrote:
>
> El Vie 06 Jul 2001 23:41, escribiste:
> > make it public in CDPeer (or if that does not work, give it a new name)
> >
> > CDPeer.java
> >
> > public Vector doSelectJoinLocation(...)
> > {
> > return super.doSelectJoinLocation(...);
> > }
>
> I'm afraid It didn't work
> I did this...
>
> in CDPeer.java
>
> public static Vector doSelectJoinLocation(Criteria c) throws Exception
> {
>
> return BaseCDPeer.doSelectJoinLocation(c);
>
> }
>
> in Screen1.java
>
> private Vector getEntries()
> {
> try
> {
> Criteria criteria = new Criteria();
> criteria.addJoin(CDPeer.LOCATION_ID, LocationPeer.LOCATION_ID );
> return CDPeer.doSelectJoinLocation(criteria);
> }
> catch (Exception e)
> {
> return null;
> }
> }
>
> Only the CD data was made available to the velocity screen. I was under the
> impresion that doSelectWithJoin() would return both CD and Location...
>
> > Saimon Moore wrote:
> > > El Vie 06 Jul 2001 22:49, escribiste:
> > > > Try for 3) results = CDPeer.doSelectJoinLocation(crit);
> > > >
> > > > Then you can get the Location by
> > > >
> > > > aCD = results.get(0);
> > > > aLocation = aCD.getLocation();
> > > >
> > > > john mcnally
> > >
> > > The compiler complains about 'CDPeer.doSelectJoinLocation(crit)'
> > > being a protected method.
> > >
> > > [javac]
> > > /home/saimon/tdk/webapps/newapp/WEB-INF/src/java/org/mycompany/newapp/mod
> > >ules/screens/CdAdminView.java:106:
> > > doSelectJoinLocation(org.apache.turbine.util.db.Criteria) has protected
> > > access in org.mycompany.newapp.om.BaseCDPeer
> > > [javac] results = CDPeer.doSelectJoinLocation(criteria);
> > > [javac] ^
> > > [javac] 1 error
> > >
> > > I'm writing a method to add the results to the context within a screen
> > > class, which is not of the same package as the doSelectJoinLocation
> > > method. So should I define it in a public method within CDPeer and call
> > > it from within my screen class.
> > >
> > > One other thing,
> > > Am I right in saying that from, what I can understand, your code provides
> > > the Location for the first 1st row of the CD resultset. Does the
> > > doSelectJoinLocation() method give you all the cd and their corresponding
> > > location objects?
> > >
> > > > Saimon Moore wrote:
> > > > > Thanks for you help folks. I managed to insert allright, although I
> > > > > had to first save the location table
> > > > >
> > > > > aLocation.save();
> > > > >
> > > > > and then
> > > > >
> > > > > aCD.setLocation(aLocation);
> > > > > aCD.save();
> > > > >
> > > > > This works great!
> > > > >
> > > > > I have tried retrieving the same data using the following code
> > > > >
> > > > > <code>
> > > > > 1 Criteria criteria = new Criteria();
> > > > > 2 criteria.addJoin(CDPeer.LOCATION_ID, LocationPeer.LOCATION_ID );
> > > > > 3 return CDPeer.doSelect(criteria);
> > > > > </code>
> > > > > However, the result set only includes the CD table data and not as I
> > > > > expected both CD and Location.
> > > > >
> > > > > ie I'm getting SELECT CD FROM CD,LOCATION
> > > > > WHERE CD.LOCATION_ID = LOCATION.LOCATION_ID
> > > > >
> > > > > instead of
> > > > >
> > > > > ie SELECT * FROM CD,LOCATION
> > > > > WHERE CD.LOCATION_ID = LOCATION.LOCATION_ID
> > > > >
> > > > > If I change 3 for
> > > > >
> > > > > return LocationPeer.doSelect(criteria);
> > > > >
> > > > > I get only the Location data
> > > > >
> > > > > ie SELECT LOCATION FROM CD,LOCATION
> > > > > WHERE CD.LOCATION_ID = LOCATION.LOCATION_ID
> > > > >
> > > > > How can I define the pre-WHERE part of the sql statement?
> > > > >
> > > > > _________________________________________________________
> > > > >
> > > > > Do You Yahoo!?
> > > > >
> > > > > Get your free @yahoo.com address at http://mail.yahoo.com
> > > > >
> > > > > ---------------------------------------------------------------------
> > > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > >
> > > > ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > >
> > > _________________________________________________________
> > >
> > > Do You Yahoo!?
> > >
> > > Get your free @yahoo.com address at http://mail.yahoo.com
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
>
> _________________________________________________________
>
> Do You Yahoo!?
>
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
