RE: descending order query

Actually, you should also trim any preceding whitespace from the field
name. If you're trying to sort on multiple columns "columnA, columnB"
gives an exception because of the space following the comma as well.

-Lou

-----Original Message-----
From: user-keelframework.org-admin-rI8AND0JKYOgdSakss0wQjfEH8FBEnyy@public.gmane.org
[mailto:user-keelframework.org-admin-rI8AND0JKYOgdSakss0wQjfEH8FBEnyy@public.gmane.org] On Behalf
Of Louis Moore
Sent: Thursday, August 12, 2004 10:09 AM
To: user-6VIttnCrOeJXNEnpj1eHPNi2O/[email protected]
Subject: RE: [Keel User] descending order query

Yeah, sounds right. My patch is working as a quick and dirty fix, but I
suppose there're probably other keywords besides ASC and DESC to think
about.

Thanks,
Lou

-----Original Message-----
From: user-keelframework.org-admin-rI8AND0JKYOgdSakss0wQjfEH8FBEnyy@public.gmane.org
[mailto:user-keelframework.org-admin-rI8AND0JKYOgdSakss0wQjfEH8FBEnyy@public.gmane.org] On Behalf
Of Shash Chatterjee
Sent: Thursday, August 12, 2004 6:54 AM
To: user-6VIttnCrOeJXNEnpj1eHPNi2O/[email protected]
Subject: RE: [Keel User] descending order query

Lou,

> Well, it didn't work -- there's no logic in DefaultPersistent to 
> strip out the ASC or DESC from the fieldname before the call to 
> getDBFieldName, so I get an exception 'myField DESC' does not exist.

Thanks for the patch.  When I get a chance, I'll change to drop
everything
following a space in the fieldname, and check it in. What do you think?

Shash
_______________________________________________
User mailing list
[email protected]
http://lists.keelframework.org/listinfo.cgi/user-keelframework.org

_______________________________________________
User mailing list
[email protected]
http://lists.keelframework.org/listinfo.cgi/user-keelframework.org