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

[Cleber Rodrigues Rosa Junior <cleberrrjr bol com br>]

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%%'"

Funny stuff, uh?

Cheers.