[sorry... I make a mistake and send this mail before to oleg directly. 
so this is a copy]

Oleg Broytmann a écrit :
> On Wed, Jun 14, 2006 at 06:29:40PM +0200, Fran?ois wrote:
>  
>> How can I make a field alias ?
>>     
>
>    There is sqlbuilder.Alias,
But Alias is for Tables, no  ? I want to make an alias of a *calculated 
field*
> and it's documented.
>   
It's probable, but before to post here, I haved a look on sqlbuilder.py, 
on website http://www.sqlobject.org/SQLBuilder.html and make some search 
on google, but I don't found the right documentation. Sorry for this...

I want to do :
SELECT COUNT(table.field1) as MyAlias
FROM table
GROUP BY table.field2
ORDER BY MyAlias DESC

> Oleg.
>   

François


_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to