Hi Renato, why dont you try to specify '%' in your input to filter. e.g %cytochrome %
syed On Tue, 2008-07-01 at 16:10 +0100, Renato Golin wrote: > 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 -- ====================================== Syed Haider. EMBL-European Bioinformatics Institute Wellcome Trust Genome Campus, Hinxton, Cambridge CB10 1SD, UK. ======================================