> print scalar @{$dbh->selectall_arrayref("
> SELECT me.id, me.name, me.description, me.created, me.updated
> FROM role me LEFT JOIN user_role map_user_role ON ( map_user_role.r=
ole_id =3D me.id )
> JOIN user user ON ( user.id =3D map_user_role.user_id ) WHERE ( use=
r.id =3D 2 )
> GROUP BY me.id, me.name, me.description, me.created, me.updated
> ")};One machine returns 1 result. One machine returns 2 results. What the hell is that all about. A jacked SQLite lib is about the only answer I have left... -=3DChris
signature.asc
Description: OpenPGP digital signature
_______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
