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]
