Re: [gnome-db] Guess we have found a bug

[Rodrigo Moya <rodrigo gnome-db org>]

On Wed, 2001-12-05 at 12:58, Cleber Rodrigues Rosa Junior wrote:
> On Wed, 2001-12-05 at 14:00, Gonzalo Paniagua Javier wrote:
> > Quer ter seu próprio endereço na Internet?
> > Garanta já o seu e ainda ganhe cinco e-mails personalizados.
> > DomíniosBOL - http://dominios.bol.com.br
> > 
> > 
> > 
> > 
> > 
> > On Wed, Dec 05, 2001 at 09:16:34AM -0200, Cleber Rodrigues Rosa Junior wrote:
> > > I had already escaped them! And I am not the one calling g_printf (at
> > 
> > 	Mmmm... 'Escaped' should be interpreted in the context of the
> > 	printf function. I mean, each '%' should be replaced by '%%'...
> > 	May be I didn't write the right word...
> > 
> > 	Have you done this?
> 
> Yes, I did! Maybe I didn't explain clearly enough. This was my (failing)
> query:
> 
> #define QUERY_PRODUCT_GRID "SELECT id, descricao FROM produto WHERE
> atributos LIKE '%%Vendido%%' AND descricao LIKE '%s%%''
> 
> And this is a query that actually works:
> 
> #define QUERY_PRODUCT_GRID "SELECT id, descricao FROM produto WHERE
> descricao LIKE '%s%%' AND atributos LIKE'%%Vendido%%'"
> 
the problem seems to be on the %%V. If you want 2 %% characters, you
have to escape them twice:

Anyway, it does seem correct, since %%V will be escaped to %V :-(

%%%%Vendido%%%%

cheers
-- 
Rodrigo Moya <rodrigo gnome-db org> - <rodrigo ximian com>
http://www.gnome-db.org/ - http://www.ximian.com/