>
>as far as I see ALL BaseObject Methods of boReferences that do conversion in
>upper case now marked as INDEX BY WORDS.
>
>John, if you make string/text field to be indexed by words, then it already
>can not be used for sorting. This is mentioned in docs.
>
>Check if this is issue of your problem ?
>
>
>>> I don't think this is a bug on my part, but if it is I apologize. I
>>> do think it's a problem with 1.8.9. As I've already reported, the
> >> echo bug is back with VText fields, and perhaps this is related.
>
That does seem to be the problem. OK, I can avoid this, but I only
implemented this scheme (the method) so that I could search a db and
get a case-insensitive sort of the data (so that "Z" doesn't sort
before "a"). Will a case-insensitive SQL ORDER BY be part of the new
SQL parser? If so, I can wait. If not, what other workaround is there
(I need INDEX BY WORDS, because the nonindexed search is too slow
with lots of data)?
Jon
©2001 jda |
