Have you recived your answer yet?
I would use the latest version of MySQL and do a subquery; however you could
also just read in the result set, create objects from it, and then sort those
object into an array (or vector) for display.

On Tue, 10 Jan 2006, keith smith wrote:

>   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!

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change  you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss