InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Stas

Unfortunately, I think you have to do it pretty much the way I suggested. I
know other databases have the ability to choose collation sequences. Others
allow you to include arbitrary expressions in the ORDER BY clause. In fact,
that latter feature is one of the most requested features for InstantDB and
is pretty high on the list of things I'd like to see included too. However I
don't think it's going to happen in a timeframe that's likely to be useful
to you.

Sorry.

Peter Hearty
Lutris Technologies UK Ltd.
-----Original Message-----
From: Stas Kazarin <StasK@saminfotech.com>
To: 'Peter Hearty' <peter.hearty@lutris.com>
Date: 12 July 2000 10:33
Subject: RE: ORDER BY bug


>Hi Peter,
>
>Thank you for the fast answer.
>Is it possible to skip additional fields in the query
>SELECT lower(loginname),users.* FROM USERS ORDER BY 1
>like this
>SELECT * FROM USERS ORDER BY lower(loginname)?
>
>I know the DB parameter likeIgnoreCase. Is there orderIgnoreCase? :-)
>
>I think that additional fields will be returned in a recordset. It takes
the
>CPU time and additional RAM.
>And not so good to create queries dynamically.
>
>Thanks,
>Stas Kazarin
>StasK@SamInfoTech.com <mailto:StasK@SamInfoTech.com>
>
>
>> -----Original Message-----
>> From: Peter Hearty [mailto:peter.hearty@lutris.com]
>> Sent: Monday, July 10, 2000 9:14 PM
>> To: instantDB; StasK@saminfotech.com
>> Subject: ORDER BY bug
>>
>>
>> Stas
>>
>> It looks like you get numbers first, then uppercase usernames
>> then lower
>> case usernames. That's the normal Java collation sequence for
>> Strings. If
>> you want to ignore case then you have to do something like:
>>
>> SELECT lower(loginname),users.* FROM USERS ORDER BY 1
>>
>> Or have I misunderstood the problem?
>>
>> Regards
>>
>> Peter Hearty
>> Lutris Technologies UK Ltd.
>> ------------------------------------------
>> From: Stas Kazarin
>> To: 'bugs@enhydra.org'
>> Sent: Monday, July 10, 2000 6:22 AM
>> Subject: ORDER BY bug
>>
>>
>> Gentlemen,
>>
>> We have a problem with the ORDER BY functionality. The
>> resulting list is
>> devided into two ordered pices.
>>
>> The our database is attached.
>> Plz, execute SELECT * FROM USERS ORDER BY LOGINNAME to get
>> this bug. You
>> have to see the ordered list  from "33" to "Tyler Noyes" and
>> from "a" to
>> "|fdiallo|".
>> We tested it with InstantDB 3.13 and 3.14 beta 7.
>>
>> Thank you,
>> Stas Kazarin
>> StasK@SamInfoTech.com
>>
>>
>

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.