def getxpfilelist(cur):
    str = "select filedigest, filename from tbfile where filename like
\'%windowxp%chs%\'"
    cur.execute(str)
    files       = []
    filedigests = []
    filenames   = []
    for line  in  cur.fetchall():
        filedigests.append(line[0])
        filenames.append(line[1])
    files.append(filedigests)
    files.append(filenames)
    return files
str在执行的时候没有结果返回，请问str应该怎么去写，谢谢。
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20070405/ea4b0e68/attachment.htm 

可能要在 % 前面加 \, 试试看

隋刚 wrote::
> def getxpfilelist(cur):
>    str = "select filedigest, filename from tbfile where filename like
> \'%windowxp%chs%\'"
>    cur.execute(str)
>    files       = []
>    filedigests = []
>    filenames   = []
>    for line  in  cur.fetchall():
>        filedigests.append(line[0])
>        filenames.append(line[1])
>    files.append(filedigests)
>    files.append(filenames)
>    return files
> str在执行的时候没有结果返回，请问str应该怎么去写，谢谢。
> 

-- 
Vim 中文 Google 论坛 http://groups.google.com/group/Vim-cn

问题解决了，将str改写为如下就可以了。
    str = "select filedigest, filename from tbfile where filename like %s" %
"'%windowsxp%chs%'"


在07-4-5，隋刚 <blackjacksg at gmail.com> 写道：
>
>
> def getxpfilelist(cur):
>     str = "select filedigest, filename from tbfile where filename like
> \'%windowxp%chs%\'"
>     cur.execute(str)
>     files       = []
>     filedigests = []
>     filenames   = []
>     for line  in  cur.fetchall():
>         filedigests.append(line[0])
>         filenames.append(line[1])
>     files.append(filedigests)
>     files.append(filenames)
>     return files
> str在执行的时候没有结果返回，请问str应该怎么去写，谢谢。
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20070405/c7025e0b/attachment.html