Hmm, based on your sly tone I'm thinking it can't :) Let me try to wrap my head around that for a moment.
On Dec 18, 9:37 pm, "Mark Mandel" <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
