Hi, I have to order queries by a part of the string. In MySQL this looks like "SELECT * FROM table ORDER BY SUBSTRING(table.field, 4,3)"
and after a patch of sql.py "db().select(db.table.ALL, orderby=db.table.field[3:3])" I could test this only with MySQL and Sqlite. The code is already at Massimo. Regards Martin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
