It's unclear to me if sqlalchemy can handle some of the odd functional call conventions in mysql. In specific, I'd like to use the "SEPARATOR" director to the group_concat() function. I can use as.select( [ sa.func.group_concat( somecol ), groubycolumn ] ), but in pure SQL I would do: select group_concat( somecol separator " : " ), groupbycolumn from mytable group by groupbycolumn;
Is there a way to do this using SA? Reference: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html Thanks, e. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
