Colin Manning wrote:
Hi
Assume I have a simple table for a phone directory - names, addresses,
and phone numbers etc.
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?
First thing that comes to my mind is to do
select count(*) from pb where name <= 'John Doe'
-veikko
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
