Re: [sqlite] FTS3 - operator

:14 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] FTS3 - operator > > > On Jan 21, 2009, at 11:43 PM, Mike Marshall wrote: > > > Hi all > > > > > > > > Quick question > > > > > > > > Should the - operator

[sqlite] FTS3 - operator

Hi all Quick question Should the - operator work in FTS in conjunction with the phrase operator i.e. router -"ip address" sqlite3_step returns SQLITE_ERROR which leads me to believe its invalid but the question is should it be invalid, it seems a perfectly valid use of the syntax to

[sqlite] Problems with FTS NEAR operator

Hi all I'm having problems with using the FTS NEAR/n operator and I'm really not sure why. Code below, any help gratefully received, the 'product NEAR announcement' produces a hit but 'product NEAR/20 announcement ' doesn't. Using 3.6.2 Thanks in advance Mike sqlite3* pHandl

Re: [sqlite] SQLite under c++

Do something like this sqlite3_stmt* pStatement; vector vResults; int nError = sqlite3_prepare_v2(pHandle,"SELECT col1 FROM table",-1,&pStatement,NULL); while (sqlite3_step(pStatement) == SQLITE_ROW) { vResults.push_back((char*)sqlite3_column_text(pStatement, 0)); } sqlite3_fina

Re: [sqlite] FTS3 Question

ation code and feed it back to the match. -scott [BTW, 'query' and 'text' are probably not strong column names, being part of SQL syntax already.] On Mon, May 19, 2008 at 11:36 PM, Mike Marshall <[EMAIL PROTECTED]> wrote: > What I'm trying to do is get the query str

Re: [sqlite] FTS3 Question

As presented, you've got "I do this, it doesn't work", which I can agree with. But I can't quite figure out what your intention for "works" is :-). -scott On Sat, May 17, 2008 at 12:49 AM, Mike Marshall <[EMAIL PROTECTED]> wrote: > I have an FTS3 tab

[sqlite] FTS3 Question

I have an FTS3 table created as follows CREATE VIRTUAL TABLE data USING fts3(guid, text) And a standard table created thus CREATE TABLE category (label, query) What I would like to be able to do is an SQL query of the form SELECT guid FROM data WHERE text MATCH SELECT query

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

[sqlite] Param Binding Problem

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); n

RE: [sqlite] Should the next release be 3.5.4 or 3.6.0?

Seems like a 3.5.4 to me Mike - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Is this a valid use of attach?

attach? "Mike Marshall" <[EMAIL PROTECTED]> wrote: > Possibly a stupid question but I'm trying to do an attach and then query via > a single sqlite3_exec() statement. > > > > Is the following a valid use? It is if the name of your database file is literall

[sqlite] Is this a valid use of attach?

Possibly a stupid question but I'm trying to do an attach and then query via a single sqlite3_exec() statement. Is the following a valid use? sqlite3_exec(pDB,"ATTACH dbpath as universe;select * from othertable where identifier IN (select identifier from universe.identifierlist)",cbfn,NULL,

RE: [sqlite] Single row insert speeds

What platform are you running on? Most of these sorts of issues that have come up before relate to the fact that SQLite is committing the data to the disc with each insert and has to ensure that the buffer has been written before it can process the next insert. IIRC there is a PRAGMA to switch th

RE: [sqlite] Re: Callback fonction really not flexible to use

Here's something from some code I was working on this morning that hopefully will help sqlite3_stmt* pStatement; char* acQuery = sqlite3_mprintf("SELECT feedurl FROM feeds WHERE pageurl = '%q'",sUrl.c_str()); int nError = sqlite3_prepare_v2(m_pDB,acQuery,-1,&pStatement,NULL); while (nError == SQLI

RE: [sqlite] Adding additional operators to FTS3

operators to FTS3 "Mike Marshall" <[EMAIL PROTECTED]> wrote: > > 1) We need to be able to index items such as AT&T, this seems like > it's a case of replacing the default tokeniser with our own implementation Correct. > > 2) A NEAR query operat

[sqlite] Adding additional operators to FTS3

Hi all Currently we use SQLite in several of our products (feel free to add us to the companies page, Lexalytics - www.lexalytics.com) and are now looking at replacing the fulltext engine in one of those projects with FTS. We've done some testing etc (on fts2) and are pretty sure that it can

RE: [sqlite] Skype client using SQLite?

The same file appears on the windows version -Original Message- From: Jeremy Hinegardner [mailto:[EMAIL PROTECTED] Sent: 28 August 2007 17:05 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Skype client using SQLite? On Tue, Aug 28, 2007 at 03:13:47PM +, [EMAIL PROTECTED] wrote: >

RE: [sqlite] Trying to compile under VC.NET

Just switch off the Using Precompiled Headers directive in the project you are compiling Project -> Properties -> C/C++ -> Precompiled Headers And everything will be AOK Mike M -Original Message- From: Henning Folger [mailto:[EMAIL PROTECTED] Sent: 13 December 2005 08:08 To: sqlite-use

Re: [sqlite] Errors on release mode during link

I'm guessing you have a mismatch on the code generation for the sqlite lib and the server component. Thats what normally causes that sort of error in VC. Mike M - Original Message - From: "Vanessa V. Nihues" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 17, 2004 8: