有时我会遇到这样的函数错误
groupId = cursor.fetchone()[0]
File "src\pymssql.pyx", line 507, in pymssql.Cursor.fetchone
但并非总是如此。groupFilter获取值如下test1,test2,test3
有时只能获取test1
或test2
我的函数如下所示
elif groupFilter:
OneMoreList = 'WHERE groupId = '
lst = groupFilter.split(",")
for element in groupFilter.split(","):
print(element)
groupId = element
cursor.execute("SELECT groupId from dbo.CalGroups WHERE groupName='{0}'".format(groupId))
groupId = cursor.fetchone()[0]
if len(lst) == 1:
OneMoreList = OneMoreList + str(groupId)
print(OneMoreList)
else:
OneMoreList = OneMoreList + str(groupId) + ' AND groupId = '
print(OneMoreList)
if len(lst) > 1:
OneMoreList = OneMoreList[-15]
print(":)")
print(OneMoreList)
知道问题出在哪里吗
目前没有回答
相关问题 更多 >
编程相关推荐