no... the tables are actually named 'Groups', 'Users', 'mapGroups_Users'. i also made the change to mapGroups_Users.userID and mapGroups_Users.groupID (removing the plurality) prior to making the post... so the data schema i posted was incorrect. sorry!
and... i was playing with the getGroupsArray() ... actually removed that commented code just after posting.... i originally was sending the collection back as an array. UPDATE: i've installed the latest version of railo 3.1.0.022 ... and still get the same error. i'm downloading CF8 to my macbook now. :) -jim On Tue, Jul 14, 2009 at 9:22 PM, Ezra Parker <[email protected]> wrote: > > Hi Jim, > > I don't know what the story is with the specific error message you're > receiving, but I think I can point out a few issues with the > schema/configuration/code you posted: > > First off, is your group table actually named "group"? If so, this > will cause problems because the SQL that Transfer generates does not > escape table names, and will therefore fail when attempting to > reference this table, as it is a reserved word in SQL (e.g., GROUP > BY). I believe that you can add brackets to the XML config if you're > using SQL Server, but I don't think the Transfer XSD allows backticks > to escape for MySQL: > > > http://groups.google.com/group/transfer-dev/browse_thread/thread/d3fe14990464d26b/c18097e57e9ded11 > > http://groups.google.com/group/transfer-dev/browse_thread/thread/2b3509744a540bb2/8a017820d6361cb3 > > Next, if the schema and XML you posted for your many-to-many are > accurate, then you have a mismatch between the column names in the DB > and the XML config. Your schema listing indicates that the column > names are plural (usersID and groupsID), but your XML column > references are singular (userID and groupID), so one or the other > needs to be changed. > > Finally, it's commented out in your code sample, but I noticed that > you are calling getGroupArray() on your user Transfer object. This is > also going to fail, both because the M2M has not been defined as an > array, and because the name of the relationship is "groups", not > "group". If you want to be able to return an array of group objects > from the user object, then you will need to change the collection type > to an array, and call it using getGroupsArray(). > > HTH, > > -- > Ezra Parker > > > > On Tue, Jul 14, 2009 at 7:01 PM, Jim Rising<[email protected]> > wrote: > > 3.1.0.015 express... older beta. i'll try upgrading to 3.1.0.022. i might > > see if i can reproduce in CF8 as well. :) > > > > -jim > > > > > > On Tue, Jul 14, 2009 at 7:52 PM, Mark Mandel <[email protected]> > wrote: > >> > >> Looks like a bug in railo, what version of Railo are you using? > >> > >> Mark > >> > >> On Wed, Jul 15, 2009 at 10:44 AM, Jim Rising <[email protected]> > >> wrote: > >>> > >>> any ideas? :) > >>> > >>> -- > >>> Jim Rising > >>> Serial Entrepreneur > >>> Software Engineer > >>> Web Developer > >>> > >>> "Knowledge work requires both autonomy and accountability." > >>> > >>> > >> > >> > >> > >> -- > >> E: [email protected] > >> T: http://www.twitter.com/neurotic > >> W: www.compoundtheory.com > >> > >> > >> > > > > > > > > -- > > Jim Rising > > Serial Entrepreneur > > Software Engineer > > Web Developer > > > > "Knowledge work requires both autonomy and accountability." > > > > > > > > > > > -- Jim Rising Serial Entrepreneur Software Engineer Web Developer "Knowledge work requires both autonomy and accountability." --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
