On Sun, Oct 23, 2011 at 2:21 PM, Baruch Burstein wrote:
> I have done something similar and it worked for me, but there is an issue
> with indexes you should take into account, as discussed here:
> http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2011-July/031470.html
Thanks a lot for
Navaneeth.K.N wrote:
> I am trying to use parameters in a LIKE query. I have the following
> code which uses Sqlite C/C++ API.
>
> const char *sql = "SELECT word FROM words WHERE word LIKE ?1 || '%'
> ORDER BY freq DESC LIMIT 10;";
>
> int rc = sqlite3_prepare_v2 (db, sql, -1, &stmt, NULL);
> if
On Sat, Oct 22, 2011 at 11:53 PM, Navaneeth.K.N wrote:
> I hooked up sqlite3_trace and
> sqlite3_profile and printed the SQL being executed. Unfortunatly,
> these routines won't give the SQL with values bound to it.
>
sqlite3_trace() does, since version 3.6.21 (2009-12-07). What version of
SQLi
I have done something similar and it worked for me, but there is an issue
with indexes you should take into account, as discussed here:
http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2011-July/031470.html
.
Out of curiosity (since this query and it's field names seem very similar to
on
Hello,
I am trying to use parameters in a LIKE query. I have the following
code which uses Sqlite C/C++ API.
const char *sql = "SELECT word FROM words WHERE word LIKE ?1 || '%'
ORDER BY freq DESC LIMIT 10;";
int rc = sqlite3_prepare_v2 (db, sql, -1, &stmt, NULL);
if ( rc != SQLITE_OK )
retu
5 matches
Mail list logo
