From: Enlightenment S. <no-...@en...> - 2012-01-31 18:07:45
|
Log: sql queries require quoted input Author: discomfitor Date: 2012-01-31 10:07:39 -0800 (Tue, 31 Jan 2012) New Revision: 67651 Trac: http://trac.enlightenment.org/e/changeset/67651 Modified: trunk/PROTO/esskyuehl/src/tests/test_sqlite.c Modified: trunk/PROTO/esskyuehl/src/tests/test_sqlite.c =================================================================== --- trunk/PROTO/esskyuehl/src/tests/test_sqlite.c 2012-01-31 18:07:38 UTC (rev 67650) +++ trunk/PROTO/esskyuehl/src/tests/test_sqlite.c 2012-01-31 18:07:39 UTC (rev 67651) @@ -128,7 +128,7 @@ { char buf[100]; snprintf(buf, sizeof(buf), "some-text-%10d", i); - id = esql_query_args(e, ctx, "INSERT INTO t (i, s) VALUES (%d, %s)", + id = esql_query_args(e, ctx, "INSERT INTO t (i, s) VALUES (%d, '%s')", i, buf); assert(id > 0); //esql_query_callback_set(id, on_query_populate, ctx); |