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