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


		
---------------------------------
Yahoo! Photos – Showcase holiday pictures in hardcover
 Photo Books. You design it and we’ll bind it!