On Sun, Apr 22, 2007 at 02:05:36PM -0300, Jorge Godoy wrote: > model.VResultadoResumo.q.nomePacienteNormalizado.startswith( > func.f_v_texto(nome_paciente))) [skip] > ((neolab.v_resultados_resumo.nome_paciente_normalizado) LIKE > ('_v_texto('jo'%'))) ORDER BY id > ================================================================================ > > It is missing the 'f' in 'f_v_texto' and misses one closing parenthesis. > Also, I don't know why it is quoting the function name.
This is the result of sqlbuilder._LikeQuoted.__sqlrepr__() that incorrectly processes its expression. Instead of removing quotes it removes the first letter and adds excessive quotes. Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss