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