You don't need the newest MySQL to do subqueries (though it has a lot  
of other nice stuff you may want).  Current stable version is 5.0,  
but subqueries are available in 4.1+.

alex

On Jan 30, 2006, at 2:09 PM, Bryan.ONeal@asu.edu wrote:

> 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

.



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