Hi all

 

I'm trying to get param binding working and I'm obviously doing something
wrong

 

My code is

 

acQuery = sqlite3_mprintf("SELECT rowid FROM fulltext_%s WHERE contents
MATCH '? '",sTempTableRoot.c_str());

nError = sqlite3_prepare_v2(m_pHandle,acQuery,-1,&pStatement,NULL);         

nError =
sqlite3_bind_text(pStatement,1,m_sQuery.c_str(),-1,SQLITE_TRANSIENT);

 

nError from the prepare is SQLITE_OK but from the bind its SQLITE_RANGE

 

Anyone got any ideas where I'm going wrong, or is it the fact that I'm
trying to do a bind on a MATCH (fts) that is giving me the problem.

 

Any and all help gratefully received

 

Mike

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to