Richard Holland wrote:
Can you check the generated SQL to see if it is actually getting through?
Hi Richard,
I hacked it and made the names different (to print me the query again)
and the like is wrong:
(UNIPROT__DESCRIPTION__dm.text_1054 like 'Cytochrome')
Where it should be "like '%Cytochrome%'"...
The full query:
SELECT renato1.UNIPROT__DESCRIPTION__DM.text_1054 FROM
renato1.UNIPROT__DESCRIPTION__DM, renato1.UNIPROT__DESCRIPTION__dm,
renato1.UNIPROT__ENTRY__MAIN main WHERE
(UNIPROT__DESCRIPTION__dm.text_1054 like 'Cytochrome') AND
main.dbentry_id_1039_key=renato1.UNIPROT__DESCRIPTION__DM.dbentry_id_1039_key
AND
main.dbentry_id_1039_key=<*>UNIPROT__DESCRIPTION__dm.dbentry_id_1039_key
AND rowNum < 201
cheers,
--renato
