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