I would give it a onetomany a go but it really seems like manytoone is the right fit. For example, an answer will only ever reference one piece of userContent, and the userContent will never care about the answer .... seems like a manytoone. Whereas a question will always have many answers, seems like a onetomany (which is how it's defined and working well). I mean, I could rename the columns to have the foreign keys not be named the same as the id in the userContent object. Such as, "lnkUserContentId", but I'm thinking that wouldn't solve the problem anyway since I am having the same problem with textualLessonId, which is clearly not named the same as the primary key in the userContent.UserContent object (userContentId).
Does it seem like I'm doing something wrong in Transfer with how things are currently configured? Thanks again for your insight, Brian On Dec 18, 5:45 pm, "Mark Mandel" <[email protected]> wrote: > What about onetomany? > > On Fri, Dec 19, 2008 at 9:15 AM, Brian FitzGerald > > > > <[email protected]> wrote: > > > Hey Mark, > > > Thank you for your response. You're correct, there many objects are > > referencing "userContentId" in a manytoone relationship with the > > UserContent object. Some have their foreign key named userContentId, > > and some do not. But that shouldn't be a problem, should it? For > > example, here's how the Answer object looks: > > > <object name="Answer" table="answer"> > > <id name="answerId" type="numeric"/> > > <property name="isCorrectAnswer" type="boolean"/> > > <property name="position" type="numeric"/> > > <manytoone name="userContent"> > > <link to="userContent.UserContent" column="userContentId" /> > > </manytoone> > > </object> > > > Hmm.... or maybe that is a problem ? > > > On Dec 18, 3:44 pm, "Mark Mandel" <[email protected]> wrote: > >> What places do you have 'userContentId' defined, there must be more > >> than what you are showing. > > >> Is it possible you write a onetomany that points to the UserContent > >> object, with a FK of userContentId ? > > >> Do a search of your config for 'userContentId', and see if you can > >> find all the places where it exists. > > >> Mark > > >> On Fri, Dec 19, 2008 at 6:19 AM, Brian FitzGerald > > >> <[email protected]> wrote: > > >> > Hey all, I've been working fine w/ onetomany,manytomany, and manytoone > >> > throughout this application, but for some reason I can't figure out > >> > this one issue. I am sure I am making a basic error, and would be > >> > most grateful if someone could point me in the right direction. I am > >> > receiving the following db error: > > >> > "Column 'userContentId' cannot be null" > > >> > I've stripped down the following code to just what's relevant. My > >> > "Lesson" definition has a manytoone link with the userContent > >> > table .... which stores the actual textual content for the lesson in > >> > multiple languages. The foreign key in the lesson table is > >> > textualLessonId > > >> > <object name="Lesson" table="lesson"> > >> > <id name="lessonId" type="numeric"/> > >> > <manytoone name="textualLesson"> > >> > <link to="userContent.UserContent" column="textualLessonId" /> > >> > </manytoone> > >> > </object> > > >> > <object name="UserContent" table="userContent"> > >> > <id name="userContentId" type="numeric" /> > >> > <property name="textEng" type="string" /> > >> > <property name="textSpa" type="string" /> > >> > <property name="longTextEng" type="string" /> > >> > <property name="longTextSpa" type="string" /> > >> > <property name="audioEng" type="string" /> > >> > <property name="audioSpa" type="string" /> > >> > <property name="image" type="string" /> > >> > <property name="difficulty" type="numeric" /> > >> > <manytoone name="audioUser" lazy="true"> > >> > <link to="user.User" column="audioUserId" /> > >> > </manytoone> > >> > </object> > > >> > For some reason, the generated SQL is including a null 'userContentId' > >> > in the update statement. It really shouldn't be in the update > >> > statement at all. > > >> > UPDATE userContent > > >> > SET textEng = 'Textual lesson for Greetings', > >> > textSpa = 'Lección textual para Saludos', > >> > longTextEng = 'my long text in eng', > >> > longTextSpa = '', > >> > audioEng = '', > >> > audioSpa = '', > >> > image = '', > >> > difficulty = '0.0', > >> > audioUserId = '46.0', > >> > userContentId = 'null' < ----------- problem > > >> > WHERE userContentId = '277' > > >> > Does anyone have any idea why the userContentId is being placed in the > >> > set portion of the update statement? Thanks a ton for any > >> > suggestions. > > >> > Brian > > >> -- > >> E: [email protected] > >> W:www.compoundtheory.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 -~----------~----~----~----~------~----~------~--~---
