Re: Using GROUP BY and COUNT

Thank you for the reply.

Pardon my ignorance, but I'm not sure how to specify that driver that I'd
like to use using bsqlodbc. I get the following error when I attempt my
query:

"[unixODBC][Driver Manager]Data source name not found, and no default
driver specified"

Do you have any idea how I can tell it to use a specific driver in
odbcinst.ini?

Thanks for the help!


On Wed, Dec 19, 2012 at 1:21 PM, James K. Lowden <[email protected]>wrote:

> On Wed, 19 Dec 2012 09:49:46 -0500
> Jeremy Livingston <[email protected]> wrote:
>
> > I am using FreeTDS v0.91 with unixODBC, PHP 5.3.10, and SQL Server
> > 2008. I have my connection to use the 7.2 protocol. I am attempting
> > to run the following query:
> >
> > SELECT COUNT(o0_.orderItemId) AS sclr0
> > FROM Membership m1_
> > LEFT JOIN OrderItem o0_ ON m1_.membershipId = o0_.membershipId
> > GROUP BY m1_.membershipId
> >
> > This query only throws an error when there is a Membership that has no
> > records in the OrderItem table.
>
> Does your query work with bsqslodbc?  I tried something similar with no
> problem:
>
> $ bsqlodbc -S$S -U$U -P$P <<< 'select count
> (c.type) from systypes t left join syscolumns c on t.type = c.type
> group by t.type'
> ----------
>          0
>          6
>         16
>        122
>        640
>         12
>         54
>         57
>          5
>         28
>          2
>        196
>          3
>          8
>          2
>         26
>          2
>         72
>          2
>
> --jkl
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>