Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque
I done a path to make this works, if someone wants! Now... CREATE TABLE a (a, b); INSERT INTO a VALUES (0, 0); INSERT INTO a VALUES (0, 1); INSERT INTO a VALUES (1, 0); INSERT INTO a VALUES (1, 1); SELECT * FROM a WHERE a.a = :a AND a.b = ?1; SELECT * FROM a WHERE a.a = ?1 AND a.b = :b;

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque
abase" <sqlite-users@sqlite.org> Enviadas: Segunda-feira, 14 de Junho de 2010 15:41:01 Assunto: Re: [sqlite] Parametrized Queries issue (Possible bug) On Mon, Jun 14, 2010 at 03:03:52PM -0300, Israel Lins Albuquerque scratched on the wall: > I know what you booth are are

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Jay A. Kreibich
On Mon, Jun 14, 2010 at 03:03:52PM -0300, Israel Lins Albuquerque scratched on the wall: > I know what you booth are are saying. But if this is a limitation of sqlite, > this need be documented, and doesn't have any comment of this behavior. http://sqlite.org/lang_expr.html#varparam

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque
- De: "David Bicking" <dbic...@yahoo.com> Para: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Enviadas: Segunda-feira, 14 de Junho de 2010 13:06:02 Assunto: Re: [sqlite] Parametrized Queries issue (Possible bug) I think in your first

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread David Bicking
said, you should not mix named and numbered parameter syntax. David --- On Mon, 6/14/10, Israel Lins Albuquerque <israel...@polibrasnet.com.br> wrote: > From: Israel Lins Albuquerque <israel...@polibrasnet.com.br> > Subject: Re: [sqlite] Parametrized Queries issue (Possible b

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Jay A. Kreibich
On Mon, Jun 14, 2010 at 12:07:08PM -0300, Israel Lins Albuquerque scratched on the wall: > Yes. I know that, but the names of parameters are different, > and I debug this and the parameter named as ':a' will be overwrited by '?1', > and if I use sqlite3_bind_parameter_index(stmt, ":a") will

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque
De: "Jay A. Kreibich" <j...@kreibi.ch> Para: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Enviadas: Segunda-feira, 14 de Junho de 2010 12:00:32 Assunto: Re: [sqlite] Parametrized Queries issue (Possible bug) On Mon, Jun 14, 2010 at 11:51:07A

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Jay A. Kreibich
On Mon, Jun 14, 2010 at 11:51:07AM -0300, Israel Lins Albuquerque scratched on the wall: > Using the example above I see one not documented issue. When I use parameters > ?NNN and : or @ or $ , > in same query as above some of then will be omitted. I don't know if this is > the

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque
Once more detail... Doing this... SELECT * FROM a WHERE a.a = :a AND a.b = ?1; and this... SELECT * FROM a WHERE a.a = ?1 AND a.b = :b; Will have different behavior! - Mensagem original - De: "Israel Lins Albuquerque" Para: