You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Emmanuel Bardet <em...@bardet.org> on 2002/01/30 16:46:00 UTC
Torque: Joining tables What am I doing wrong ?
Hello guys,
Pretty straight forward but I can't make it work!
This code:
Criteria critUnit = new Criteria();
critUnit.addJoin( TarMenuNamePeer.NAME_ID,
TarMenuUnitLanguageNamePeer.NAME_ID );
critUnit.addJoin( TarMenuUnitLanguageNamePeer.UNIT_ID,
TarMenuFoodPeer.UNIT_ID );
critUnit.addJoin ( TarMenuFoodPeer.FOOD_ID,
tarMenuFoodLanguageName.getFoodId().toString() );
critUnit.add (TarMenuUnitLanguageNamePeer.LANGUAGE_ID, language_id);
Vector vector = TarMenuNamePeer.doSelect( critUnit );
throws an exception:
Exception: java.lang.StringIndexOutOfBoundsException: String index out of
range: -1
Stack Trace follows:
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java:1525)
at org.apache.turbine.om.peer.BasePeer.createQueryString(BasePeer.java:1033)
at org.apache.turbine.om.peer.BasePeer.doSelect(BasePeer.java:1131)
at
com.mctar.menu.om.BaseTarMenuNamePeer.doSelectVillageRecords(BaseTarMenuName
Peer.java:197)
at
com.mctar.menu.om.BaseTarMenuNamePeer.doSelect(BaseTarMenuNamePeer.java:167)
I don't see what I'm doing wrong here. Can anybody help ?
Thanks.
Emmanuel.
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Torque: Joining tables What am I doing wrong ?
Posted by Emmanuel Bardet <em...@bardet.org>.
But of course. Silly me. Thanks and sorry.
> -----Original Message-----
> From: Wolfgang Klier [mailto:wolfi@nautilus.noreply.org]
> Sent: mercredi 30 janvier 2002 17:30
> To: Turbine Users List
> Subject: Re: Torque: Joining tables What am I doing wrong ?
>
>
> Hi
> On Wed, Jan 30, 2002 at 03:46:00PM -0000, Emmanuel Bardet wrote:
> > critUnit.addJoin ( TarMenuFoodPeer.FOOD_ID,
> > tarMenuFoodLanguageName.getFoodId().toString() );
>
> This is no JOIN, but a constraint.
>
> Wolfgang
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Torque: Joining tables What am I doing wrong ?
Posted by Wolfgang Klier <wo...@nautilus.noreply.org>.
Hi
On Wed, Jan 30, 2002 at 03:46:00PM -0000, Emmanuel Bardet wrote:
> critUnit.addJoin ( TarMenuFoodPeer.FOOD_ID,
> tarMenuFoodLanguageName.getFoodId().toString() );
This is no JOIN, but a constraint.
Wolfgang
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>