[PEAK] sql quoting

Phillip J. Eby pje at telecommunity.com
Mon Nov 1 12:27:04 EST 2004


At 04:54 PM 10/31/04 -0500, R. David Murray wrote:
>In debuging my datetime problem I noticed that sqlite has this cute
>auto-quoting feature.  Is the bulletins example just out of date,
>or does PEAK not have an sql quoting facility?

I don't recall for sure, but I don't think so, unless there's one in 
n2.  That's because 1) most of our production use of PEAK SQL was in an 
application that already had its own quoting, and 2) most "enterprise" 
quality DBAPI drivers don't need it when you use the driver's argument 
interpolation.  However, I can see that it's possible a poorly-written 
Python driver that actually uses Python's '%' interpolation might fail to 
handle it properly.




More information about the PEAK mailing list