How to process the nested String for sybase sql statement?

boyeestudio boyee118 at gmail.com
Wed Apr 4 12:07:48 EDT 2007


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 "<stdin>", 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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20070405/0468fbd6/attachment.html>


More information about the Python-list mailing list