Re: [sqlite] Param Binding Problem

Thanks to Dan and Dennis for the heads up, all works great now Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote Sent: 12 March 2008 17:12 To: General Discussion of SQLite Database Subject: Re: [sqlite] Param Binding Problem Mike Marshall

Re: [sqlite] Param Binding Problem

Mike Marshall wrote: > > acQuery = sqlite3_mprintf("SELECT rowid FROM fulltext_%s WHERE contents > MATCH '? '",sTempTableRoot.c_str()); You need to remove he quotes around the ? following MATCH. With the quotes it is a literal string containing a question mark. Without them it is a parameter

Re: [sqlite] Param Binding Problem

On Mar 12, 2008, at 11:40 PM, Mike Marshall wrote: > 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());