[DB-SIG] Why the varying paramstyles in DB-API?

Paul DuBois paul@dubois.ws
Fri, 24 Nov 2000 15:51:31 -0600


At 1:39 PM -0800 11/24/00, Greg Stein wrote:
>On Thu, Nov 23, 2000 at 10:48:22AM -0600, Paul DuBois wrote:
>  >...
>  > My question springs out of examination of the MySQLdb driver, which uses
>>  the format paramstyle.  As far as I can tell, that parameter style gives you
>>  printf-style formatting, nothing more, nothing less.  It doesn't add quotes
>>  around substituted values, doesn't escape special characters, doesn't turn
>>  None into NULL in the resulting query string, etc.
>
>You are probably looking at an old version. As somebody already stated, the
>latest MySQLdb does proper binding, where you don't need to do any quoting.

Actually, it turned out to be complete stupidity on my part.  Jon Ribbens
pointed out to me what I was doing wrong; all works as it should.

Thanks, all.