PySQLite Problem

[Jordan Krushen]

On Fri, 09 May 2003 22:26:21 -0700, Tim Roberts <timr at probo.com> wrote:

> alc at PublicPropertySoftware.com wrote:

>> Is there any better solution than to use the tick marks and wrap all my 
>> calls to PySQLite to double the ticks on the way
>> in and undouble them on the way out?

> No.  That's exactly the right way to do it.

>> TIA for not laughing.

> Not at all.  This is a real issue when doing SQL from within a 
> programming languange.

>From most languages, yes.  From a certain high-level, introspective 
language, however, it's far easier than that.

As has been noted before, the DB-API automatically quotes vars based on 
type.  Simply using %s, without quotes, will allow the adaptor to add 
quotes itself if needed.

computers-are-good-at-automating-things-ly y'rs,

J.