Hello, The SQL statement produced by the following query is trimmed or cut-off somehow and therefore produces an error. Surely this must be a bug?
In [5] : print db(db.holiday.leave_type == db.leave_type.id)._select(db.leave_type.name, db.holiday.working_days.sum(), groupby=db.holiday.leave_type) SELECT leave_type.name, SUM(holiday.working_days) FROM leave_type, holiday WHERE (holiday.leave_type = leave_type.id) GROUP BY holiday.leave_typ; As you can see the GROUP BY field has been cut-off and show "leave_typ" instead of "leave_type". I think this is only happening in MS SQL Server as I did not have this issue when using SQLite. I am using the following web2py version: Version 2.4.5-stable+timestamp.2013.03.18.22.46.22 Does anyone else experience this issue? Regards, Edwin. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
