[python-sybase] Parameter passing with freetds/MSSQL2000

Marcos Sánchez Provencio msanchez at grupoburke.com
18 Feb 2003 13:59:12 +0100


--=-hUPYzyq9q+pHqBZI4HhW
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

Hello

What is the current status regarding parameter passing with
freetds/MSSQL2000? I get an error if I try simple queries.

import Sybase as dbapi

con=3Ddbapi.connect('cazalla','gotta','password','personal')
cur=3Dcon.cursor()
cur.execute('select * from usuarios where cd_usuario=3D@u', =20
{'@u':'marcos'})
pprint.pprint(cur.fetchall())

This is what I get (line numbers are incorrect)

Traceback (most recent call last):
  File "etcPythonSybase.py", line 191, in ?
    cur.execute('select * from usuarios where
cd_usuario=3D@u',{'@u':'marcos'})
  File "/usr/lib/python2.2/site-packages/Sybase.py", line 379, in
execute
    self._raise_error(Error, 'ct_param')
  File "/usr/lib/python2.2/site-packages/Sybase.py", line 309, in
_raise_error
    raise exc(text)
Sybase.Error: ct_param
--=20
gpg --recv-keys --keyserver wwwkeys.pgp.net B9AD9B1B

--=-hUPYzyq9q+pHqBZI4HhW
Content-Type: application/pgp-signature; name=signature.asc

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQA+Ui4fTwXdxLmtmxsRApozAJ0Sdm04BhdCs4MFyHqG+wRsA1cBvQCfXJjt
aLZ6gz49WWRY9kcuEGdpVvw=
=UUh9
-----END PGP SIGNATURE-----

--=-hUPYzyq9q+pHqBZI4HhW--