On Mar 28, 2008, at 8:06 AM, Julien wrote:
>
> ##### Problem is here #####
> func.count(
> select(
> [sp.c.id],
> sp.c.site_id.in_(
> select(
> [model.t_sites.c.id],
> and_(
> model.t_sites.c.latitude != None,
> model.t_sites.c.longitude != None,
> )
> )
> )
> )
> ).label('specimen_filtered_georeferenced'),
> ##############################
>
I think you want to convert the select to a scalar, i.e.
count(myselect.as_scalar()).
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
