Re: swing / mysql / jdbc search question

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