[python-sybase] Problem binding params with FreeTDS

[Nicholas Veeser]

I am using FreeTDS 0.61


I am doing a basic bind with parameters and I am getting an error.

    cursor =3D conn.cursor()
    comps =3D ('a', 'b', 'c')

    for comp in comps:
        cursor.execute("SELECT id, queuetype FROM Components WHERE id =
=3D '@' ", {'@n' : comp} )

        (c,qtype) =3D cursor.fetchone()

        print comp, qtype

    cursor.close()

My results are thus...

Traceback (most recent call last):
  File "./DB.py", line 69, in ?
    _query3(conn)
  File "./DB.py", line 56, in _query3
    cursor.execute("SELECT id, queuetype FROM Components WHERE id =3D =
'@n'", { '@n' : comp} )
  File "/usr/local/lib/python2.2/site-packages/Sybase.py", line 380, in =
execute
    self._raise_error(Error, 'ct_param')
  File "/usr/local/lib/python2.2/site-packages/Sybase.py", line 310, in =
_raise_error
    raise exc(text)
Sybase.Error: ct_param


Any thoughts?

Thanx
Nicholas