Re: [Squirrel-sql-users] queries with where clause are failing

[Rob M. <Rob...@co...>]

Kleinmann, Peter G wrote:

>I can exec 
>select count(*) from Foo 
>
>but not 
>select count(*) from Foo where Fooey = "Y" 
>  
>
How about:

select count(*) from Foo where Fooey = 'Y'


(use single instead of double quotes)



Rob Manning



CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83