Assuming this to be MySQL, will this work -
SELECT * FROM table2 WHERE id =
IF(ISNULL(${table1.somethin_like_a_foreign_key}), 0,
${table1.somethin_like_a_foreign_key});
Cheers
Avlesh
On Wed, Oct 28, 2009 at 11:12 PM, Jonathan Hendler <
jonathan.hend...@gmail.com> wrote:
> No - the SQL will fail to validate because at runtime it will look like
>
>
> SELECT * FROM table2 WHERE
>> IS NOT NULL table1.somethin_like_a_foreign_key
>> AND table1.somethin_like_a_foreign_key > 0
>> AND id =
>>
>>
>
> Note the "id = "
>
>
> On Oct 28, 2009, at 1:38 PM, Avlesh Singh wrote:
>
> 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
>>>
>>>
>
