Oleg Broytmann <[EMAIL PROTECTED]> writes:
> On Sun, Apr 22, 2007 at 09:27:02PM +0400, Oleg Broytmann wrote:
>> 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.
>
> Jorge, can you replace sqlbuilder._LikeQuoted.__sqlrepr__() with the
> following and test if works for you?
I'll do that tonight. I'm working at my client's office now and as soon
as I get to my office I'll test it for you.
--
Jorge Godoy <[EMAIL PROTECTED]>
-------------------------------------------------------------------------
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
