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;
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
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
-
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
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
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
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
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
a: "sqlite-users" <sqlite-users@sqlite.org>
Enviadas: Segunda-feira, 14 de Junho de 2010 11:51:07
Assunto: [sqlite] Parametrized Queries issue (Possible bug)
Using the example above I see one not documented issue. When I use parameters
?NNN and : or @ or $AAA
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 expected behavior or not.
CREATE TABLE a (a, b);
CREATE TABLE b (a, b);
INSERT INTO a VALUES (0,
10 matches
Mail list logo