advsql group by

[andreacfm]

Hi Steve,

how are we supposed to write adsql for group by and order by:

advsql.group_by
or
advsql.groupby

or ??

Both seems do nto work. Any suggestion??

Thanks

Andrea

[Steve Bryant]

Andrea,

Right now it actually has to be advsql["group by"]. I could certainly
add support for advsql.group_by in the next version if that would be
easier.

Steve

[Andrea Campolonghi]

Is not a problem is just unusual a var with a space.

Don't you think??

Andrea

[Steve Bryant]

Yeah, that was a difficult choice for me. On one hand, I thought that
a structure key named "group by" (or "order by") is unusual. On the
other hand, it made sense to just name the keys exactly the same as
the SQL statements.

Maybe I will just allow "group_by" or group_by in the next build.

Steve