Ron, Take a look at the example application in the Linux Journal article http://www.linuxjournal.com/article.php?sid=7803
The parameterized queries provide a much better solution than sprintf. You can grab a complete working app from the link at the end of the article. Clay Dowling Ron Aaron said: > Anyway, in my particular case I have several similar queries which differ > only > in a few specifics. Right now I sprintf() to a temp buffer and execute > that > buffer -- but I was hoping that I could use sqlite's dialect of SQL more > directly rather than cobbling together my query piecemeal. > > It doesn't matter a whole lot, as the sprintf() or equivalent would have > to be > done somewhere. But it makes my application much more messy looking and > bigger than it would otherwise have to be. -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development