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." > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
