|
From: Kleinmann, P. G <pk...@le...> - 2005-09-22 16:28:23
|
I can exec=20 select count(*) from Foo=20 but not=20 select count(*) from Foo where Fooey =3D "Y"=20 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,=20 because Squirrel shows it in the Columns tab.=20 I'm using jconn2.jar to connect to a Sybase AES 12.5, with no special options specified,=20 in Squirrel 2.0 final on a sun 1.5.0_04-b05 jvm for linux. Any suggestions=3F =20 ---------------------------------------------------------------------------= --- 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 a= s= 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 b= e= secure or error-free. Therefore, we do not represent that this informatio= n= is complete or accurate and it should not be relied upon as such. All = information is subject to change without notice. |
