LIKE pyPqSQL SOLUCIONADO

[Chema Cortes]

FERNANDO VILLARROEL escribió:

> Aca va el error
> 
> Traceback (most recent call last):
>   File "like.py", line 10, in ?
>     cur.execute(q,(c,))
>   File
> "/usr/lib/python2.3/site-packages/pyPgSQL/PgSQL.py",
> line 3072, in execute
>     raise OperationalError, msg
> libpq.OperationalError: ERROR:  syntax error at or
> near "vilna" at character 157
> Aca el script de prueba:
> 
> c="vilna"
> q="select a.razonsocial,b.descripcion from cltescred
> as a, comunas as b \
> where a.ccomuna=b.ccomuna and a.razonsocial like '%s'
> "
> cur.execute(q,(c,))
> 
> A que se debera?

Quita los apóstrofes en el query. Es labor del módulo DB-API añadirlos:

q="select a.razonsocial,b.descripcion from cltescred
as a, comunas as b \
where a.ccomuna=b.ccomuna and a.razonsocial like %s
"