回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我抓到了一些需要用Python和PyODBC更新的SQL id:</p>
<pre><code>import pyodbc
cnxn = pyodbc.connect('DSN=YesOne;PWD=xxx')
cursor = cnxn.cursor()
cursor.execute("SELECT ID FROM One.dbo.Two WHERE STATUS = 'OnGoing' AND ID = ''")
</code></pre>
<p>我有第二段代码可以更新ID:</p>
^{pr2}$
<p>问题是,当我在Python中查看抓取的id时,我会得到:</p>
<pre><code>row = cursor.fetchall()
f row:
print row
</code></pre>
<blockquote>
<p>[(1016, ), (1017, ), (1019, ), (1020,
), (1021, ), (1025, ), (1026, ),
(1027, ), (1029, ), (1048, ), (1049,
)]</p>
</blockquote>
<p>或者</p>
<pre><code>if row:
print row[3]
</code></pre>
<blockquote>
<p>(1020, )</p>
</blockquote>
<p>我只需要数字,这样我就可以运行脚本的第二部分:</p>
<pre><code>WHERE ID = '1051'"
</code></pre>
<p>部分。我试过:</p>
<pre><code>count = len(row)
while count > 0:
newrow = row[count-1]
print 'SELECT ID FROM One.dbo.Two WHERE ID = ' + str(newrow)
count = count-1
</code></pre>
<p>它给了我:</p>
<blockquote>
<p>SELECT ID FROM One.dbo.Two WHERE ID = (1049, )<br/>
SELECT ID FROM One.dbo.Two WHERE ID = (1048, )<br/>
etc...</p>
</blockquote>
<p>我试着:</p>
<pre><code>str(row[1]).lstrip('(),')
</code></pre>
<p>我得到了:</p>
<blockquote>
<p>'1017, )'</p>
</blockquote>
<p>如何从ID中删除字符以便重用ID?在</p>
<p>谢谢</p>
<p>阿德里安</p>