[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--