Farrukh Najmi wrote:
>
>>
>> Please try the following:
>> SELECT thing FROM Thing thing
>> LEFT OUTER JOIN thing.name name LEFT OUTER JOIN
>> name.localizedStrings name_ls
>> LEFT OUTER JOIN thing.description desc LEFT OUTER JOIN
>> desc.localizedStrings desc_ls
>
> I get a syntax error for above line:
>
> unexpected token: desc near line 3, column 50 [ SELECT OBJECT(ro) FROM
> org.freebxml.omar.jaxb.bindings.rim._4_0.RegistryObjectType ro LEFT
> OUTER JOIN ro.name name LEFT OUTER JOIN name.localizedStrings name_ls
> LEFT OUTER JOIN ro.description desc LEFT OUTER JOIN
> desc.localizedStrings desc_ls WHERE ((:name = '%') OR
> (UPPER(name_ls.value) LIKE UPPER(:name))) AND ((:description = '%') OR
> (UPPER(desc_ls.value) LIKE UPPER(:description))) ]
>
> Note column number is for my variant of above query so its not exact.
> It is basically not liking the 'desc' after thing.description in the
> line above.
>
> Any idea why? Thanks again for your terrific help.
Hi Michael,
I figured it out. Apparently 'desc' is a reserved word or some such. How
weird! Changing it to 'desc1' made your query work just fine.
Thanks you very much.
--
Regards,
Farrukh Najmi
Web: http://www.wellfleetsoftware.com