now,I want to insert some data to the sybase database,
some variable such as i,j,k,name,k,j I have defined before.
I write the sql statement here But I meet some errors,How to write this
nested String for sql query?
For example:

>>>import Sybase
>>> db = Sybase.connect('boyee','sa','',"test'')
>>> c = db.cursor()
......

 >>> values = "%d,%d,%d,%s,%d,%d" % (i,j,k,name,k,j)
 >>> c.execute("'insert into
productinfo(productid,spid,corpid,productname,type1,
type2) value(@value)',{'@value':values}")

Traceback (most recent call last):
  File "", line 1, in ?
  File "C:\Python24\lib\site-packages\Sybase.py", line 774, in execute
    self.description = fetcher.start(self.arraysize)
  File "C:\Python24\lib\site-packages\Sybase.py", line 517, in start
    return self._start_results()
  File "C:\Python24\lib\site-packages\Sybase.py", line 645, in
_start_results
    self._raise_error(Error, 'ct_results')
  File "C:\Python24\lib\site-packages\Sybase.py", line 506, in _raise_error
    raise exc(text)
Sybase.Error: ct_results

Any reply is enjoyable,Thank a lot!
-------------- 下一部分 --------------
??HTML?????...
URL: http://python.cn/pipermail/python-chinese/attachments/20070405/0468fbd6/attachment.htm