Unless there's a privacy issue, can you send me a copy of the table's
data and the query that fails? If I can reproduce it here then I'll
have it fixed.
Bambi
..
On 13/01/2006, at 6:13 PM, Gerhard Wilhelms wrote:
> David J. Hughes schrieb:
>> Hi,
>
> Hi again,
>
>> Are you suer there's no whitespace or similar on the "miss-sorted"
>> entries? A simple test here has shown the following correct results
>> (for a ASCII's idea of alphabetic ordering).
>
> as I might have mentioned earlier some times it's a migration
> project from msql2 to msql3, so (almost) the same data is
> present in msql2. That's msql2's (and my) idea of sorting properly:
>
> BelID Kurs ID Vorname Nachname Status Gebühr
> 12050 G6154 85690 Roland Conrad Gast
> 12391 G6154 86960 Angela Freudenmann Storno
> 12119 G6154 86993 Kay Greiner Gast
> 12065 G6154 84499 Daniela Krug Frei 0.00
> 12338 G6154 75368 Josef Lukas Gast
> 12423 G6154 87058 Natalie Niedermeier Gast
> 12449 G6154 87730 Heidi Sayle Frei 0.00
> 12376 G6154 87247 Ralf Schäfer Gast
> 12457 G6154 85324 Cord-Hinrich Solle Gast
> 7029 G6154 82052 Anja Stemmer Gast 460.00
> 12343 G6154 87103 Maximilian Weiß Gast
>
>
> [....]
>
> It's OK with us that words are sorted using ASCII code. We got
> used to it over the years. :-)
>
> I used msqldump to export the msql2 data. There was not a single
> problem reimporting the data into msql3. There is also no white
> space in the msql3 table adressen.ad_nachname.
>
> Best regards,
> Gerhard
>
>> On 13/01/2006, at 12:15 AM, Gerhard Wilhelms wrote:
>>> Hi,
>>>
>>> I have a problem when migration my msql2/lite application
>>> to msql3/ember. I have a query against three tables. The
>>> result is supposed to be sorted against two different
>>> variables.
>>>
>>> It seems like msql3 does not sort against the second
>>> argument of "order by". A short example: first key
>>> is Kurs (which works), second key is Nachname.
>>>
>>> BelID Kurs ID Vorname Nachname Status Gebühr
>>> 12050 G6154 85690 Roland Conrad Gast 12391
>>> G6154 86960 Angela Freudenmann Storno
>>> 12119 G6154 86993 Kay Greiner Gast 12338
>>> G6154 75368 Josef Lukas Gast 12423 G6154
>>> 87058 Natalie Niedermeier Gast 12376 G6154 87247
>>> Ralf Schäfer Gast 12457 G6154 85324
>>> Cord-Hinrich Solle Gast 12343 G6154 87103 Maximilian
>>> Weiß Gast 12467 G6154 80038 Miriam Albrecht
>>> Frei 0.00
>>> 12468 G6154 88028 Ronald Anich Frei 0.00
>>> 12065 G6154 84499 Daniela Krug Frei 0.00
>>> 12463 G6154 87542 Elisabeth Maczurek Frei 0.00
>>> 7029 G6154 82052 Anja Stemmer Gast 460.00
>>>
>>> select
>>> belegung.be_kurs,belegung.be_kosten,belegung.be_ident,belegung.be_sta
>>> tu s,
>>> adressen.ad_nummer,adressen.ad_nachname,adressen.ad_vorname,
>>> satzart.sa_text,belegung.be_nummer from
>>> belegung,adressen,satzart
>>> where belegung.be_ident=adressen.ad_nummer AND
>>> belegung.be_kurs like '_6154' AND
>>> belegung.be_status=satzart.sa_schluessel
>>> order by
>>> belegung.be_kurs,adressen.ad_nachname
>>>
>>> Obviously msql3 does not sort against adressen.ad_nachname.
>>>
>>> Any idea?
>>>
>>> Best regards,
>>> Gerhard
>>>
>>> --
>>> Dr. Gerhard Wilhelms
>>> ----------------------------------------------
>>> Tel./Fax +49-(0)821/598-4020/-4213
>>> mailto:gerhard.wilhelms@zww.uni-augsburg.de
>>> ----------------------------------------------
>>> *** Interaktionsmuster neu gestalten ***
>>> *** mit Human Dynamics - Seminar ***
>>> *** 10./11.03.2006 ***
>>> http://www.zww.uni-augsburg.de/seminare
>>> ----------------------------------------------
>>> -----------------------------------------------------------------
>>> This is the Mini SQL Mailing List operated by Hughes Technologies
>>> To unsubscribe, go to http://www.Hughes.com.au/extras/email/
>>>
>
> --
> Dr. Gerhard Wilhelms
> ----------------------------------------------
> Tel./Fax +49-(0)821/598-4020/-4213
> mailto:gerhard.wilhelms@zww.uni-augsburg.de
> ----------------------------------------------
> *** Interaktionsmuster neu gestalten ***
> *** mit Human Dynamics - Seminar ***
> *** 10./11.03.2006 ***
> http://www.zww.uni-augsburg.de/seminare
> ----------------------------------------------
>
-----------------------------------------------------------------
This is the Mini SQL Mailing List operated by Hughes Technologies
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Wed Feb 01 2006 - 00:20:00 PST