List:MySQL and Java« Previous MessageNext Message »
From:Christian Mack Date:September 8 1999 6:07pm
Subject:Re: mm.mysql with \"order by\"
View as plain text  
"Geocrawler.com" wrote:
> 
> This message was sent from Geocrawler.com by "Axel E. Christensen"
> <axel@stripped>
> Be sure to reply to that address.
> 
> I have succesfully established a connection to MySQL via mm.mysql driver. The result
> is displayed in a List (java.awt.list) in an Applet.
> I have used the following command:
> 
> String query = "select toys, children from megalist";
> 
> This works fine but when I want to order the output by:
> 
> String query = "select toys, children from megalist order by toys";
> 
> I simply do not get any data displayed in the applet.
> 
> Could this problem be related to the mm.mysql ? The query works fine when I use it
> directly in the MySQL database.
> 
> Thanks !
> 
> Axel

Hi Axel

I couldn't reproduce your problem.
I use this kind of queries every day.

What version of mm are you using?
Which JDK?
Which mysql DBMS version?
What error do you get?

Tschau
Christian

Thread
mm.mysql with \"order by\" Geocrawler.com22 Aug
  • Re: mm.mysql with \"order by\"Christian Mack8 Sep