How can the usercontentID be a FK for both a onetomany and a manytoone at the same time? :oD
Mark On Fri, Dec 19, 2008 at 1:34 PM, Brian FitzGerald <[email protected]> wrote: > > Oh! Silly me - I misunderstood. Yes, there is a onetomany pointing > to UserContent in my QuizResult object, like so: > > <object name="QuizResult" table="quizResult"> > <id name="quizResultId" type="numeric"/> > <property name="quizId" type="numeric" /> > <property name="userId" type="numeric" /> > <property name="totalCorrect" type="numeric" /> > <property name="totalQuestion" type="numeric" /> > <property name="lessonId" type="numeric" /> > <property name="dateModified" type="date" /> > <manytoone name="message"> > <link to="userContent.UserContent" column="userContentId" /> > </manytoone> > <onetomany name="incorrectAnswers"> > <link to="answer.Answer" column="answerId" /> > <collection type="array"> > <order property="answerId" order="asc" /> > </collection> > </onetomany> > <onetomany name="hints"> > <link to="userContent.UserContent" column="userContentId" /> > <collection type="array"> > <order property="userContentId" order="asc" /> > </collection> > </onetomany> > </object> > > The idea here is that one QuizResult can have many incorrect answers, > and can thus also have many hints, each of which are represented by a > piece of UserContent. > > > On Dec 18, 8:54 pm, "Mark Mandel" <[email protected]> wrote: >> No, I mean, is there a onetomany that points to your object UserContent? >> >> Mark >> >> On Fri, Dec 19, 2008 at 12:49 PM, Brian FitzGerald >> >> >> >> <[email protected]> wrote: >> >> > 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 >> >> -- >> 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 -~----------~----~----~----~------~----~------~--~---
