I'm using matchinfo(...,'s') to get the length of the longest subsequence
of phrase matches from FTS4. I have 4 columns, so I end up with a byte
array that is 16 bytes long. I would like to extract the value for the Nth
column in query and sort by it. I would also be interested in getting the
Max()
On 5/14/2013 7:47 PM, E. Timothy Uy wrote:
Hi, is it possible to bind a field name to a sqlite query?
For example,
WHERE @field1 > @param1
No. A parameter may only appear where a literal would be allowed.
--
Igor Tandetnik
___
sqlite-users mailing
Hi, is it possible to bind a field name to a sqlite query?
For example,
WHERE @field1 > @param1
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Tue, May 14, 2013 at 3:39 PM, Lauren Foutz wrote:
> test 4.10 went from:
> "SELECT group_concat(y) FROM b2 GROUP BY x" {0,1 3 2,4}
>
> To:
>
> "SELECT group_concat(y) FROM b2 GROUP BY x" {/#,# 3 #,#/}
>
The other change (that you didn't notice) is that the expected result is
now s
Recently several of the expected results in the test e_select.test were
changed to results that look very odd. Basically the numbers that were
returned by the query were replaced with lots of "#". For example, test
4.10 went from:
# EVIDENCE-OF: R-14926-50129 For the purposes of grouping rows
On May 14, 2013, at 10:12 AM, Roman Fleysher wrote:
> I am new to database and SQLite too. I found this in archive. What if I would
> like GUI, where I would go?
You could give the Firefox plugin "SQLite Manager" a try:
https://addons.mozilla.org/En-us/firefox/addon/sqlite-manager/
Regards,
Br
OK Warren, you've helped greatly, thanks again for the assistance, will
check other forums if the shared object / dll problems continue.
Keith
On Tue, May 14, 2013 at 10:53 AM, Warren Young wrote:
> On 5/14/2013 09:14, Keith Christian wrote:
>
>>
>> couldn't load file "./tclsqlite3.o": Exec fo
I am new to database and SQLite too. I found this in archive. What if I would
like GUI, where I would go?
Thank you,
Roman
I assume when you say "discrete" you actually mean "bracketed" as there are
lots more than 10 heights and weights.
I don't know what Excel has to do with this unless yo
On 5/14/2013 09:14, Keith Christian wrote:
couldn't load file "./tclsqlite3.o": Exec format error
From the Tcl manual: http://tmml.sourceforge.net/doc/tcl/load.html
"...such as a .so file under Solaris or a DLL under Windows."
Not *.o!
My Tcl is awfully rusty, but I managed to get it to loa
Of course, I understand that I haven't recovered everything, but as I said
before, I don't find any big ammount of data lost ;)
Sent: Tuesday, May 14, 2013 5:59 PM
Subject: Re: [sqlite] Malformed database recovery
On 14 May 2013, at 4:54pm, "Marcin" wrote:
Ok, I had a great idea, and propa
On 14 May 2013, at 4:54pm, "Marcin" wrote:
> Ok, I had a great idea, and propably somehow managed to repair it. I opened
> dump_all.sql in notepad, deleted two "/ ERROR: (11) database disk image
> is malformed */", changed ROLLBACK into COMMIT, and it is working so far.
The ROLLBACK i
Ok, I had a great idea, and propably somehow managed to repair it. I opened
dump_all.sql in notepad, deleted two "/ ERROR: (11) database disk image
is malformed */", changed ROLLBACK into COMMIT, and it is working so
far.
ignac8
Sent: Tuesday, May 14, 2013 5:48 PM
Subject: Re: [sqlite
If you can get the errors, by say redirecting the output from the .read to
a file, the error message will likely be enlightening. When I recover
corrupt db files, there are often some records with a conflicting primary
key. In those cases I have to edit the input to fix the old one.
Naturally, y
No errors, but tshockfixed.sqlite is empty, and in the end of file
dump_all.sql there is "ROLLBACK; -- due to errors".
It's was check of tshock.sqlite, old one.
ignac8
Sent: Tuesday, May 14, 2013 4:43 PM
Subject: Re: [sqlite] Malformed database recovery
Where there any errors on
.read dump
Warren, thanks, that built the tclsqlite3.o correctly, and a libsqlite3
file also:
-rw-r--r-- 1 kchristian Domain Users 39279 May 14 08:47 tclsqlite3.o
-rwxr-xr-x 1 kchristian Domain Users 173214 May 14 08:47
libsqlite3.7.16.2.dll
Another question, with a small test script, this error is out
On 14 May 2013, at 1:59pm, Dulini Atapattu wrote:
> If anyway I omit these sqlite commands from script, so is there anyway of
> providing the script file to API?
If you strip out the lines which start with a dot, everything else in the
script should be a legitimate SQL command. You could use
Where there any errors on
.read dump_all.sql ?
was PRAGMA integrity_check; on the new file or the old one?
On Tue, May 14, 2013 at 10:29 AM, Marcin wrote:
> Hi everybody.
>
> Somehow my database got malformed, and journal file is unfortunately
> nowhere to found.
>
> Suprisingly, I'm able to
Hi everybody.
Somehow my database got malformed, and journal file is unfortunately nowhere
to found.
Suprisingly, I'm able to open it in Sqlite Database Browser, and read stored
values. There is only minor data loss, as I can't really see what got
missing. I've also managed to figure which t
You may want to consider writing a bash/msdos-batch file and do your stuff from
your OS command line
Bıt C API is quite handy, you can do most of the stuff with it.
On 14/05/2013, at 10:29 PM, Dulini Atapattu wrote:
> If anyway I omit these sqlite commands from script, so is there anyway of
>
If anyway I omit these sqlite commands from script, so is there anyway of
providing the script file to API?
On Tue, May 14, 2013 at 6:07 PM, wrote:
> If you are dealing with CSV files, there is a simple API I wrote you can
> use.
>
> https://github.com/fnoyanisi/sqlite3_capi_extensions
>
> I wa
Ok, thanks. I understand offset will come with a performance slowdown, but
should be ok for my purpose.
However, how can I get the offset(s) as part of the rank function
implementation? The FTS offsets function is private:
SQLITE_PRIVATE void sqlite3Fts3Offsets(sqlite3_context*, Fts3Cursor*);
If you are dealing with CSV files, there is a simple API I wrote you can use.
https://github.com/fnoyanisi/sqlite3_capi_extensions
I was looking for .import functionality for C API, but I ended up writing my
own fınctions.
On 14/05/2013, at 9:39 PM, Richard Hipp wrote:
> On Tue, May 14, 2013
On Tue, May 14, 2013 at 1:53 AM, Dulini Atapattu
wrote:
> Hi all,
>
> I have some sqlite scripts with some sqlite commands like:
>
>- .headers ON
>- .mode CSV etc.
>
> Is there anyway of running this script in SqliteDB using Sqlite interface
> for C++, instead of redirecting the file to sq
On 05/13/2013 11:25 PM, Stadin, Benjamin wrote:
Hi all,
I need to implement a ranking that considers the search result's token distance
(so either the actual character offset, or token offset from the beginning of
the text). Is it possible to get/query this distance from the FTS4 index
(eithe
On Mon, May 13, 2013 at 12:25 PM, Stadin, Benjamin <
benjamin.sta...@heidelberg-mobil.com> wrote:
> Hi all,
>
> I need to implement a ranking that considers the search result's token
> distance (so either the actual character offset, or token offset from the
> beginning of the text). Is it possibl
Hi all,
I have some sqlite scripts with some sqlite commands like:
- .headers ON
- .mode CSV etc.
Is there anyway of running this script in SqliteDB using Sqlite interface
for C++, instead of redirecting the file to sqlite using sqlite command
line shell?
Thanks
__
Hi all,
I need to implement a ranking that considers the search result's token distance
(so either the actual character offset, or token offset from the beginning of
the text). Is it possible to get/query this distance from the FTS4 index
(either directly or via ft4saux), or would I have to par
Seection 2.0 line 4
SQLite processes this by gather all the output of query and then running ...
SQLite processes this by gathering all the output of query and then running
...
A
^^^
___
sqlite-users mailin
Hi all,
reading through queryplanner.html today I notice a trivial typo in section
1.6, line 5:
If there were a third column, it would be used to break ties for the first
to columns.
If there were a third column, it would be used to break ties for the first
tWo columns.
^^^
It doesn't spoil the
29 matches
Mail list logo