[transfer-dev] Re: ManyToMany Relationships order property not working
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 3darkli...@gmail.com 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 bob.silverb...@gmail.com 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 bob.silverb...@gmail.comwrote: 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 3darkli...@gmail.com 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=arrayorder 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: mark.man...@gmail.com 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 transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~--~~~~--~~--~--~---
[transfer-dev] Re: ManyToMany Relationships order property not working
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=arrayorder 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 mark.man...@gmail.com 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 3darkli...@gmail.com 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 bob.silverb...@gmail.com 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 bob.silverb...@gmail.comwrote: 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 3darkli...@gmail.com 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=arrayorder 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: mark.man...@gmail.com 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 transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~--~~~~--~~--~--~---
[transfer-dev] Re: ManyToMany Relationships order property not working
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 3darkli...@gmail.com 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=arrayorder 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 mark.man...@gmail.com 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 3darkli...@gmail.com 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 bob.silverb...@gmail.com 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 bob.silverb...@gmail.comwrote: 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 3darkli...@gmail.com 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=arrayorder 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: mark.man...@gmail.com 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 transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~--~~~~--~~--~--~---
[transfer-dev] Re: ManyToMany Relationships order property not working
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 bob.silverb...@gmail.comwrote: 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 3darkli...@gmail.com 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=arrayorder 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 Silverberg www.silverwareconsulting.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 transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~--~~~~--~~--~--~---
[transfer-dev] Re: ManyToMany Relationships order property not working
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 bob.silverb...@gmail.com 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 bob.silverb...@gmail.comwrote: 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 3darkli...@gmail.com 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=arrayorder 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 --~--~-~--~~~---~--~~ 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 transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~--~~~~--~~--~--~---