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
