Hey Mark,
here are the relevant declarations:
<object name="Bilder">
<id name="BildID" type="numeric" />
<property name="Filename" type="string" />
<property name="OrderNum" type="numeric" />
</object>
<!-- PROJEKTE -->
<package name="Projekte">
<object name="Projekte" decorator="athome.model.ProjekteDecorator">
<id name="ProjektID" type="numeric" />
...
<manytomany name="Bilder" table="ProjekteBilder">
<link to="Projekte.Projekte" column="FK_ProjektID" />
<link to="Bilder" column="FK_BildID" />
<collection type="array"><order property="OrderNum" order="asc" /
></collection>
</manytomany>
</object>
</package>
the "ProjekteBilder" table which connects the relationship doesn't
have to be declared as an object, right? the relationship and its
generated methods work fine, just the sort order doesn't.
Thanks!
On Mar 13, 7:06 am, Mark Mandel <[email protected]> wrote:
> Chris,
>
> What does the rest of the config for that object look like?
>
> Mark
>
>
>
> On Fri, Mar 13, 2009 at 2:52 AM, Chris H <[email protected]> wrote:
>
> > yes, i first had it in the ProjekteBilder Table, which did throw an
> > error. it is now in the Bilder Table and no errors is thrown, but the
> > resulting array is not sorted by that column.
> > thanks!
>
> > On Mar 12, 2:06 pm, Bob Silverberg <[email protected]> wrote:
> >> Oops, that should have read "Although I would have expected Transfer to
> >> throw an error if the OrderNum were not in the Bilder table"
> >> On Thu, Mar 12, 2009 at 9:05 AM, Bob Silverberg
> >> <[email protected]>wrote:
>
> >> > In which table is the column OrderNum? I'm guessing that maybe it's in
> >> > the ProjekteBilder table? If so, you won't have access to it. The order
> >> > property must point to a property in the Bilder table, in your example.
> >> > Although I would have expected Transfer to throw an error is the
> >> > OrderNum
> >> > were not in the Bilder table, so maybe I'm totally off base.
> >> > Bob
>
> >> > On Thu, Mar 12, 2009 at 7:29 AM, Chris H <[email protected]> wrote:
>
> >> >> hey, i have my relationship set up like this:
>
> >> >> <manytomany name="Bilder" table="ProjekteBilder">
> >> >> <link to="Projekte.Projekte" column="FK_ProjektID" />
> >> >> <link to="Bilder" column="FK_BildID" />
> >> >> <collection type="array"><order property="OrderNum" order="asc" /></
> >> >> collection>
> >> >> </manytomany>
>
> >> >> the collection is not sorted by the specified property though, even if
> >> >> i call a manual "sortBilder()" on the TO
>
> >> >> i've tried reinitializing the application, discardAll() on the cache,
> >> >> even restarted ColdFusion, no help.
>
> >> >> any ideas? thanks in advance!
>
> >> > --
> >> > Bob Silverberg
> >> >www.silverwareconsulting.com
>
> >> --
> >> Bob Silverbergwww.silverwareconsulting.com
>
> --
> E: [email protected]
> W:www.compoundtheory.com
--~--~---------~--~----~------------~-------~--~----~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
You received this message because you are subscribed to the Google Groups
"transfer-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
