SyBaseDA and select count problem
It seems that whenever I try to use any of the following: select count(*) from <tablename> select count(<columnname>) from <tablename> it returns: "Error, exceptions.ValueError: Empty column name, " Of course, the sql is tested and known to work. Any clues here? -- Bill Anderson Linux/Unix Administrator, Security Analyst ESBU (ARC) bill_anderson@boi.hp.com My opinions are just that; _my_ opinions.
Bill Anderson wrote:
It seems that whenever I try to use any of the following: select count(*) from <tablename> select count(<columnname>) from <tablename>
it returns: "Error, exceptions.ValueError: Empty column name, "
Of course, the sql is tested and known to work.
Any clues here?
nevermind .. I found one ... *doh* -- Bill Anderson Linux/Unix Administrator, Security Analyst ESBU (ARC) bill_anderson@boi.hp.com My opinions are just that; _my_ opinions.
On 1/7/00 4:02 PM, Bill Anderson at banderson@boi.hp.com wrote:
Bill Anderson wrote:
It seems that whenever I try to use any of the following: select count(*) from <tablename> select count(<columnname>) from <tablename>
it returns: "Error, exceptions.ValueError: Empty column name, "
Of course, the sql is tested and known to work.
Any clues here?
nevermind .. I found one ... *doh*
In case it was the wrong one :-) select count(*) as result from <table> All returned values must have a column name to bind to :-) Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli@digicool.com http://www.digicool.com
Does anybody know how to access the icons that Zope uses for its objects (folders, DTML Documents, etc.) for a Z Class I created, or where that info might be found? I know I could just load the icon image from the "lib/python/Products/OFSP/images" directory, but I'm trying to figure out how to do it without using up extra space in the database for that image (assuming that I'm not misunderstanding that bit...) (No... in the long run, it probably doesn't matter for such small images, and usually I'd just make my own image anyway, but it'll give me a slightly better idea of Zope's structure and this particular class isn't enough to bother with a new icon.) - Gregor
participants (3)
-
Bill Anderson -
Christopher Petrilli -
Gregor