Re: [sqlite] How to get row number of an ID in sorted results

Thanks. In answer to your question a page of results is displayed in a grid on the screen. The user selects a row. If they then change the sort order I want to show the page that contains the selected row (and reselect it). Each row has a unique ID and i need to know the position in the result set

Re: [sqlite] SQLite comes bundled with the Python programming language?

2016-11-13 21:09 GMT+01:00 Simon Slavin : > > On 13 Nov 2016, at 6:00pm, no...@null.net wrote: > >> On Sun Nov 13, 2016 at 10:31:09AM -0700, Keith Medcalf wrote: >> >>> (1) is correct. SQLite is included in the Python distribution. >>> (2) is incorrect. SQLite distribution

Re: [sqlite] Unable to connect

2016-11-14 7:47 GMT+01:00 jungle boogie : > On 11/13/2016 10:29 PM, Cecil Westerhof wrote: >> >> When going to www.sqlite.org I get: >> Unable to connect >> > > Also happening for me. > > Use https://www.sqlite.org/ until non-https is restored. That works, thanks. --

Re: [sqlite] Unable to connect

On 11/13/2016 10:29 PM, Cecil Westerhof wrote: When going to www.sqlite.org I get: Unable to connect Also happening for me. Use https://www.sqlite.org/ until non-https is restored. ___ sqlite-users mailing list

[sqlite] Unable to connect

When going to www.sqlite.org I get: Unable to connect -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to get row number of an ID in sorted results

On 11/13/2016 6:17 PM, Mike King wrote: Sorry to reply again so soon. I'm just playing about with your query. The values in Value1 and Value2 are not unique so I don't think your method would work. Well, in this case, your problem is under-specified. How do you plan to assign a number to a

Re: [sqlite] How to get row number of an ID in sorted results

Sorry to reply again so soon. I'm just playing about with your query. The values in Value1 and Value2 are not unique so I don't think your method would work. Cheers, On 13 November 2016 at 19:47, Igor Tandetnik wrote: > On 11/13/2016 12:29 PM, Mike King wrote: > >> So,

Re: [sqlite] How to get row number of an ID in sorted results

Wow, that's clever and obvious :) Taking this a stage further, the problem is that in the real app the user enters a query so there'll be a where clause to content with as well as the sort order. So, I think I'll use a CTE to build a list of the selected data and then use your query to select a

Re: [sqlite] SQLite comes bundled with the Python programming language?

On 13 Nov 2016, at 6:00pm, no...@null.net wrote: > On Sun Nov 13, 2016 at 10:31:09AM -0700, Keith Medcalf wrote: > >> (1) is correct. SQLite is included in the Python distribution. >> (2) is incorrect. SQLite distribution files do not include Python. > > I would say that the sentence as

Re: [sqlite] How to get row number of an ID in sorted results

On 11/13/2016 12:29 PM, Mike King wrote: So, after some experimentation, I'm using a temporary table to hold the ordered IDs and then getting the rowid of the row with the ID I want. (in this example the list is sorted by Value2 and the selected ID=1): create temporary table TempIDs as select

Re: [sqlite] How to get row number of an ID in sorted results

Yes spot on.I did come up with a hybrid prototype which used a binary chop to work out what to read from the database and offset / limit to read the pages. This was slower than the temp table. To muddy the waters a bit thecquery is keyed in by the user so to calculate the page in code I'd have to

Re: [sqlite] How to get row number of an ID in sorted results

On 2016/11/13 7:29 PM, Mike King wrote: I have a table (test) with 3 columns (ID - auto incrementing, Value1 - Text and Value2 - Text). After doing an order by in a select query I'd like to know the row number that contains a particular ID. (The real world use is this: I have an application

Re: [sqlite] SQLite comes bundled with the Python programming language?

On Sun Nov 13, 2016 at 10:31:09AM -0700, Keith Medcalf wrote: > > (1) is correct. SQLite is included in the Python distribution. > (2) is incorrect. SQLite distribution files do not include Python. I would say that the sentence as constructed is ambiguous and could be interpreted both ways.

Re: [sqlite] SQLite comes bundled with the Python programming language?

(1) is correct. SQLite is included in the Python distribution. (2) is incorrect. SQLite distribution files do not include Python. > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Cecil Westerhof > Sent: Sunday, 13 November,

[sqlite] How to get row number of an ID in sorted results

I have a table (test) with 3 columns (ID - auto incrementing, Value1 - Text and Value2 - Text). After doing an order by in a select query I'd like to know the row number that contains a particular ID. (The real world use is this: I have an application which displays paged lists of results. If you

[sqlite] SQLite comes bundled with the Python programming language?

At: http://www.sqlite.org/famous.html I see: SQLite comes bundled with the Python programming language since Python 2.5. Should that not be: The Python programming language comes bundled with SQLite since Python 2.5. -- Cecil Westerhof

[sqlite] Encryption

I am not sure about sqlite2009, but you edit DBs that are encrypted using the encryption in system.data.sqlite. I use SQLITE Expert. It allows you to replace the standard library which does not support encryption to one from the system.data.sqlite that does. It is the interop dll that you

Re: [sqlite] BUG: crash in fts5MultiIterNext()

> > Got a crash in the FTS5 code which only happens on a specific search > > query (int the form of: "ab cd" OR "ab cd" *) > > The crash occurs In fts5MultiIterNext(), on the following line: > > > > pSeg->xNext(p, pSeg, ); > > > > Debugger shows that pSeg is set, but xNext is null. > > > >

[sqlite] add "LINE" to famous sqlite user list

http://www.sqlite.org/famous.html should add https://en.wikipedia.org/wiki/Line_(application) . See https://www.google.com/search?q=Sqlite+Naver+LINE P.S., http://www.sqlite.org/src/wiki?name=Bug+Reports needs to remove the now broken Gmane links. ___