Using Concat in ORDER BY

[Trevor DeVore]

On Nov 29, 2004, at 11:58 PM, Ruslan Zasukhin wrote:

> On 11/30/04 3:43 AM, "Trevor DeVore" <lists at mangomultimedia.com> wrote:
>
>> Hi,
>>
>> I'm converting some SQL I have running in MySQL over to Valentina 1.x.
>> I have a query which orders records returned using the Concat 
>> function.
>>   Here is a simplified query which shows the basic concept:
>>
>> SELECT Title, Sequence FROM lesson ORDER BY Concat(Sequence, '.', 
>> Title)
>>
>> I keep getting 604 syntax errors though.  Is this type of ordering
>> possible in Valentina 1.x and if so what is the proper syntax?
>
> Hi Trevor,
>
> You need create BaseObject mehod and use it in the ORDER BY

Thanks. I've got that working now.


-- 
Trevor DeVore
Blue Mango Multimedia
trevor at mangomultimedia.com