AS alias and ORDER_BY

[ferllings]

Hello,

Using mysql, I'm trying to get list of users first letter:

    stmt := SELECT(
        LEFT(User.name, Int(1)).AS("letter"),
    ).DISTINCT().FROM(
        User,
    ).ORDER_BY(
        String("letter").ASC(),
    )

It produce:

SELECT DISTINCT LEFT(user.name, 1) AS "letter"
FROM user
ORDER BY 'letter' ASC;

It gets the list, but not sorted. Any idea?

[houten11]

Replace String("letter") with StringColumn("letter"). Ordering by a string constant doesn't make sense.

[ferllings]

Sorry for the confusion, I'm only starting with this lib. Great job so far !