gt; 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 work
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*
Do something like this
sqlite3_stmt* pStatement;
vector vResults;
int nError = sqlite3_prepare_v2(pHandle,"SELECT col1 FROM
table",-1,,NULL);
while (sqlite3_step(pStatement) == SQLITE_ROW)
{
vResults.push_back((char*)sqlite3_column_text(pStatement, 0));
}
, '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 strings that are stored in category
> executed against the text stored in dat
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 table created as follows
>
>
>
> CREATE VIRTUAL TABLE data USING fts3(guid, text)
>
>
>
> And a standard table cre
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
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
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,,NULL);
nError =
Seems like a 3.5.4 to me
Mike
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
of 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 literally &qu
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
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
operators to FTS3
"Mike Marshall" <[EMAIL PROTECTED]> wrote:
>
> 1) We need to be able to index items such as AT, this seems like
> it's a case of replacing the default tokeniser with our own implementation
Correct.
>
> 2) A NEAR query operator so we can
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
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:
>
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:
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
17 matches
Mail list logo