Scott: Something is indeed fishy. What os, version of python, and version of pywin32 are you using? As an attempt to duplicate your result, I built a table "tblTemp" on my Windows Vista laptop's SQL express 2008 with three VarChar fields and loaded two rows of data. I defined an ODBC DSN to point to my local server, since you are running in ODBC mode.
I added some debug details to your sample, corrected a typo, altered the database info, and ran the following... <python program x.py> #Note: odbcTest is a DSN defined using "Control Panel"->"Administrative Tools"->"Data Sources (ODBC)" connStrSQLServer = 'Data Source=odbcTest;Initial Catalog=Northwind;' + 'Trusted_Connection=true;' import sys print sys.version import adodbapi print 'adodbapi version=',adodbapi.version adodbapi.adodbapi.verbose = 4 cnctn = adodbapi.connect(connStrSQLServer) c = cnctn.cursor() # Note: corrected from crsr = cnctn.cursor() query = 'SELECT fword, text, cui FROM TblTemp' c.execute(query) print 'description=',repr(c.description) rows = c.fetchall() print repr(rows[0]) print repr(rows[1]) c.close() cnctn.close() </python> I got this result... <console dump> C:\hg\adodbapi\test>c:\python26\python.exe x.py 2.6.4 (r264:75708, Oct 26 2009, 08:23:19) [MSC v.1500 32 bit (Intel)] adodbapi version= adodbapi v2.4.0.2 adodbapi v2.4.0.2 attempting: "Data Source=odbcTest;Initial Catalog=Northwind;Tusted_Connection=true;" adodbapi New connection at 2C70450 adodbapi New cursor at 2C70BF0 on conn 2C70450 Executing command="SELECT fword, text, cui FROM TblTemp" with parameters= [] description= [(u'fword', 200, 6, 10, 255, 255, True), (u'text', 200, 15, 30, 255, 255, True), (u'cui', 200, 8, 12, 255, 255, True)] <SQLrow={fword:u'breast', text:u'what goes here?', cui:u'C0006142'}> <SQLrow={fword:u'breast', text:u'breast carcinoma', cui:u'C0006142'}> adodbapi Closed connection at 2C70450 </console dump> Try again with verbose=4 all of the "print repr(..." lines added, and see if the additional information helps. -- Vernon On Thu, Dec 30, 2010 at 4:07 PM, Halgrim, Scott <halgri...@ghc.org> wrote: > Has anybody ever had an issue like this? > > I submit a query to a table and everything works out fine, except for one > column in one row. The column of type text in the first row returned is > always None. I’ve modified the query by adding a WHERE clause so that a > different row was the first one returned, and the same thing happens where > the first row returned has a None in that column. > > I’m running adodbapi 2.4 and querying SQL Server 2008. Here’s my code. > > >>> from adodbapi import connect > >>> cnctn = connect('Data Source=InstanceName;Initial Catalog=DbName;' + > 'Trusted_Connection=true;') > >>> crsr = cnctn.cursor() > >>> query = 'SELECT fword, text, cui FROM TABLE' > >>> c.execute(query) > >>> rows = c.fetchall() > >>> print rows[0], rows[1] > (u'breast', None, u'C0006142') (u'breast', u'breast carcinoma', > u'C0006142') > > Any help is appreciated. > > Thanks, > > Scott > > > * ________________________________ * > GHC Confidentiality Statement > > This message and any attached files might contain confidential information > protected by federal and state law. The information is intended only for the > use of the individual(s) or entities originally named as addressees. The > improper disclosure of such information may be subject to civil or criminal > penalties. If this message reached you in error, please contact the sender > and destroy this message. Disclosing, copying, forwarding, or distributing > the information by unauthorized individuals or entities is strictly > prohibited by law. > > _______________________________________________ > python-win32 mailing list > python-win32@python.org > http://mail.python.org/mailman/listinfo/python-win32 > >
_______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32