<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Arial, sans-serif" size="2">
<div>Has anybody ever had an issue like this?</div>
<div><font face="Times New Roman, serif" size="3"> </font></div>
<div>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.</div>
<div> </div>
<div>I’m running adodbapi 2.4 and querying SQL Server 2008. Here’s my code.</div>
<div><font face="Times New Roman, serif" size="3"> </font></div>
<div>>>> from adodbapi import connect</div>
<div>>>> cnctn = connect('Data Source=InstanceName;Initial Catalog=DbName;' + 'Trusted_Connection=true;')</div>
<div>>>> crsr = cnctn.cursor()</div>
<div>>>> query = 'SELECT fword, text, cui FROM TABLE'</div>
<div>>>> c.execute(query)</div>
<div>>>> rows = c.fetchall()</div>
<div>>>> print rows[0], rows[1]</div>
<div>(u'breast', None, u'C0006142') (u'breast', u'breast carcinoma', u'C0006142')</div>
<div><font face="Times New Roman, serif" size="3"> </font></div>
<div>Any help is appreciated.</div>
<div> </div>
<div>Thanks,</div>
<div> </div>
<div>Scott</div>
<div><font face="Times New Roman, serif" size="3"> </font></div>
<div><font face="Times New Roman, serif" size="3"><br>
</font></div>
<div><font face="Times New Roman, serif" size="3"><u> ________________________________ </u></font></div>
<div><font face="Verdana, sans-serif" color="#808080">GHC Confidentiality Statement<br>
<br>
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.<br>
</font></div>
</font>
</body>
</html>