never mind, i was updating the order column with manual SQL and of course the cache didn't pick this up. still have to wrap my head around this new workflow with Transfer ;D i called discardByClassAndKey() on the parent object after the manual update and all is good now. thanks for all your replies though!
On Mar 13, 9:56 am, Chris H <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
