MSSQL+FreeTDS+Sybase-python returning (0,)?

Joshua Ginsberg <[email protected]> Mon, 08 Nov 2004 14:28:48 -0700
Newsgroups gmane.comp.python.sybase
Organization Brainstorm Internet Network Operations
Message-ID <[email protected]>
Hello --

I've been using the Sybase module 0.36 for a few months now, and it has
been exceptionally helpful in our enterprise -- thank you so much for
writing it!

However, in developing a new bit of code this morning, I've spent all
day banging my head against a wall trying to figure out what's causing
this.

I'm having to do some complex data mining, and so I've done a few
"select into" statements, and now I'm trying to run a query against that
new table. I'm selecting three columns out of one of these temporary
tables, but when I run the fetchone method on my cursor, it returns (0,)
-- a tuple of length one.

Running my same query in Query Analyzer returns my results perfectly, so
I'm pretty sure the query isn't the problem.

Any thoughts? I've paged through the module code a little bit looking
for what might be causing this, but I can't figure anything out. Thanks
for any help you can provide.

-jag

-- 
Joshua Ginsberg <[email protected]>
Brainstorm Internet Network Operations