Re: problem with pydo, possible fix ?

On Wed, Jan 05, 2005 at 12:03:24AM +0100, Fredrik Bj?rnsson wrote:
> I have a problem with some database queries containing, %(keyname)s
> 
> in file lib/pylibs/PyDO/postconn.py line 86
> 
>         cur.execute(sql) #original
>         cur.execute(sql,values) # my change
> 
> seems to fix the problem, I don't know if this is correct
> but I thought I should log it to the list.

My archaelogy may be mythology, but I think this probably dates from a
time when pygresql didn't support bind variables.

I see that psycopgconn has the same code; I'll review all the drivers
in this regard.

Incidentally, I strongly recommend using psycopg over pygresql.  I
have the core files to justify my preference.

Thanks,

js

> 
> //Fredrik
> 
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by: Beat the post-holiday blues
> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
> _______________________________________________
> Skunkweb-list mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/skunkweb-list
> 

-- 
Jacob Smullyan

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

iD8DBQFB3NJ3uqamFyFXXLIRAkonAJ4x93zecD98l4ZAOa70sB5MpsMaWgCff6fv
AYvTcFgWGbUA71zM8Yva6uA=
=Pp4O
-----END PGP SIGNATURE-----