python中for cycle的问题

2024-03-29 09:44:12 发布

您现在位置:Python中文网/ 问答频道 /正文

有时我会遇到这样的函数错误

    groupId = cursor.fetchone()[0]
  File "src\pymssql.pyx", line 507, in pymssql.Cursor.fetchone

但并非总是如此。groupFilter获取值如下test1,test2,test3有时只能获取test1test2我的函数如下所示

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)

知道问题出在哪里吗