On 6/14/07, Derek Watson <[EMAIL PROTECTED]> wrote: > 1. A fatal error is thrown when the object count is zero. I believe > this is happening around line 2749 of MakeMethods::Generic: > > $count = > $ft_manager->$ft_count_method(query => [EMAIL PROTECTED], db => > $self->db, %args) > or die $ft_manager->error; > > Which dies because $count is assigned zero, making the statement > evaluate false.
Whoops, careless copy/paste. That's fixed in SVN now. > 2. If I am counting objects related by a many-to-many where the > mapping table has a multi-valued primary key, the query generated is > something like > > SELECT > COUNT(DISTINCT t1.a_id, t1.b_id) > FROM > a_b_map t1 > JOIN b t2 ON (t1.b_id = t2.id) > WHERE > t1.a_id=xxx > > But Postgres says > > ERROR: function count(integer, integer) does not exist at character 9 Hm, what is the correct SQL in that case for Postgres? -John ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
