"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
