Hi Plug folks,

I posted a question to the Java Users Group and received limited feedback.

I know some of you do Java also.

Any help appreciated.

I am writing a simple swing/mysql/jdbc form that has previous, next, add, save, edit, del, exit buttons.

The resultset is People and next, previous, add, save (update) , delete, and exit button code work ok.

The problem I am having difficulty with is doing a search, example:

Say I have a MySql table with 1000 records in my resultset. I want to "order" it by phone number which is not unique. I need to find a phone number within that resultset which say is at record 700. (this is a swing desktop application)

How do I do the search within this resultset?

Thanks a bunch,

Keith