Can you please remove all webtaggers.com email addresses from the castor-dev
mailing list?
thanks in advance,
-r
>From: Bruce Snyder <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: Re: [castor-dev] Re: Howto handle multiple reference to same table
>with castorjdo
>Date: Fri, 3 May 2002 09:23:48 -0600 (MDT)
>
>This one time, at band camp, Franck Routier said:
>
>FR>Mapping file is :
>FR>
>FR> <class name="ldp.data.Team" identity="Id">
>FR> <description>Equipe</description>
>FR> <map-to table="teams" />
>FR> <field name="Id" type="integer" >
>FR> <sql name="id" type="integer"/>
>FR> </field>
>FR> <field name="Name" type="string">
>FR> <sql name="name" type="char"/>
>FR> </field>
>FR> <field name="Mhome" type="ldp.data.Match" collection="collection">
>FR> <sql many-key="home"/>
>FR> </field>
>FR> <field name="Mvisit" type="ldp.data.Match" collection="collection">
>FR> <sql many-key="visitor"/>
>FR> </field>
>FR> </class>
>FR>
>FR> <class name="ldp.data.Match" identity="Id">
>FR> <description>Match</description>
>FR> <map-to table="matches" />
>FR> <field name="Id" type="integer" >
>FR> <sql name="id" type="integer"/>
>FR> </field>
>FR> <field name="Home" type="ldp.data.Equipe">
>FR> <sql name="home"/>
>FR> </field>
>FR> <field name="Visitor" type="ldp.data.Equipe">
>FR> <sql name="visitor"/>
>FR> </field>
>FR> </class>
>FR>
>
>Franck,
>
>Using two separate collections and forcing Castor to do mulitple
>outer joins on the same table twice in the same query is not going
>to work (as you've already seen).
>
>This is a difficult problem to solve because what you're really
>trying to do is join on two object instances where the objects are
>both of type Team. This is simply my opinion in terms of using
>Castor so take or leave it.
>
>If this were my problem to solve first, I would actually only use
>one collection because you're really fetching the same data twice
>just sorting it different each time. Then I would sort that Collection
>in your application code using either the mhome field or the mvisitor
>field, depending on the scenario. My resoning for this is that it
>seems as if you're trying to accomplish business logic via the
>database rather than via your application.
>
>Again, this is only my opinion. Oftentimes I've seen scenarios posed
>similar to this one. In fact, I've even done it myself. In these
>cases, because you're using object-relational mapping, you need to
>approach the problem from a different angle.
>
>Bruce
>--
>
>perl -e 'print
>unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
>
>-----------------------------------------------------------
>If you wish to unsubscribe from this mailing, send mail to
>[EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
