Shouldn't this work too?
SELECT * FROM table2 WHERE IS NOT NULL
${table1.somethin_like_a_foreign_key} AND
${table1.somethin_like_a_foreign_key} > 0 AND id =
${table1.somethin_like_a_foreign_key}
Cheers
Avlesh
On Wed, Oct 28, 2009 at 11:03 PM, Jonathan Hendler <
jonathan.hend...@gmail.com> wrote:
> I have a nested entity on a jdbc data import handler that is causing an SQL
> error because the second key is either NULL (blank when generating the sql)
> or non-zero INT.
> The query is in the following form:
>
> <document name="content">
> <entity name="bl_lessonfiles"
> transformer="TemplateTransformer" query="SELECT * FROM table1 ">
> ...
> <entity name="user_index" query="SELECT * FROM
> table2 WHERE id = ${table1.somethin_like_a_foreign_key} ">
> ....
> </entity>
> </entity>
> </document>
>
> Is the only way to avoid this to modify the source DB schema to be NOT NULL
> so it always returns at least a 0?
>
> - Jonathan
>
