I think you can find information in this mailing list.
Take a look at:
http://castor.exolab.org/list-archive/msg09309.html
Florian.
Adam Esterline a �crit :
>
> I am almost positive that everything is mapped correctly. Everything works
> and gets loaded properly
> when I try and query the main attributes (the attributes contained in the
> COURSE table). I only
> encounter a problem when I try and query the many-to-many relationship. It
> looks to me that it is not
> generating the SQL statement correctly?
>
> SELECT
> "COURSE"."course_code","COURSE"."course_name","COURSE"."program_code","COU
> RSE"."descr","COURSE"."status","COURSE"."comment","COURSE_CATEGORY"."cat_cod
> e" FROM "COURSE","COURSE
> _CATEGORY" WHERE "COURSE"."course_code"*="COURSE_CATEGORY"."course_code" AND
> ("COURSE"."cat_code" =
> ? AND "COURSE"."program_code" = ? AND "COURSE"."status" = ?)
>
> I think that the last part should be "COURSE_CATEGORY".cat_code = ? instead
> of "COURSE".cat_code.
...
>
> Any help would be appreciated.
>
> Adam
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
