queries with where clause are failing

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

queries with where clause are failing

Kleinmann, Peter G


I can exec
select count(*) from Foo

but not
select count(*) from Foo where Fooey = "Y"

I get the following error message:
Error: com.sybase.jdbc2.jdbc.SybSqlException: Invalid column name
'Fooey'., SQL State: ZZZZZ, Error Code: 207


Somehow though the driver does know that the column exists,
because Squirrel shows it in the Columns tab.


I'm using jconn2.jar to connect to a Sybase AES 12.5, with no special
options specified,
in Squirrel 2.0 final on a sun 1.5.0_04-b05 jvm for linux.


Any suggestions?  


------------------------------------------------------------------------------
This message is intended only for the personal and confidential use of the designated recipient(s) named above.  If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited.  This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction, or as an official statement of Lehman Brothers.  Email transmission cannot be guaranteed to be secure or error-free.  Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such.  All information is subject to change without notice.




-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|

Re: queries with where clause are failing

Rob Manning
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




-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users