On 7/17/07 5:13 PM, "Colin Manning" <[EMAIL PROTECTED]> wrote:
>
> Not a problem. I can use "SELECT * FROM pb ORDER BY name LIMIT x,y" etc as
> my user pages up and down the list, or drags a scrollbar.
>
> Next, assume the user wants to jump to a specific record in the list, or to
> (say) the first entry for a specific name.
>
> How do you do this with sqlite, without forcing the the app to fetch every
> record and then do a manual comparison in the app?
SELECT MIN(rowid) FROM pb ORDER WHERE name LIKE 'John Smith'
Will return first index of the row matching the given condition.
Hope this answers your question.
Cheers,
Bharath Booshan L.
-----------------------------------------------
Robosoft Technologies - Come home to Technology
Disclaimer: This email may contain confidential material. If you were not an
intended recipient, please notify the sender and delete all copies. Emails to
and from our network may be logged and monitored. This email and its
attachments are scanned for virus by our scanners and are believed to be safe.
However, no warranty is given that this email is free of malicious content or
virus.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
