Re: [sqlite] SQL query, finding out which row a result is in

2007-04-23 Thread Gilles Roy
On Mon, Apr 23, 2007 at 09:26:53AM -0400, Stephen Oberholtzer wrote: On 4/22/07, Gilles Roy <[EMAIL PROTECTED]> wrote: Given a arbitrary statement, I need to find out which row a specific result is in, as efficiently as possible. The arbitrary statement can order the results any way it

Re: [sqlite] SQL query, finding out which row a result is in

2007-04-22 Thread Gilles Roy
On Sun, Apr 22, 2007 at 05:33:43PM -0500, P Kishor wrote: On 4/22/07, Gilles Roy <[EMAIL PROTECTED]> wrote: Given a arbitrary statement, I need to find out which row a specific result is in, as efficiently as possible. The arbitrary statement can order the results any way it wants. w

[sqlite] SQL query, finding out which row a result is in

2007-04-22 Thread Gilles Roy
Given a arbitrary statement, I need to find out which row a specific result is in, as efficiently as possible. The arbitrary statement can order the results any way it wants. For example, imagine statement X which returns a column of memberid. They can be ordered by first name, last name,