Re: [sqlite] Parameterized queries -- howto?

2004-10-21 Thread Ron Aaron
On Thu, October 21, 2004 7:51, Clay Dowling said: > 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

Re: [sqlite] Parameterized queries -- howto?

2004-10-21 Thread Clay Dowling
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

Re: [sqlite] Parameterized queries -- howto?

2004-10-20 Thread Ron Aaron
On Wed, October 20, 2004 18:05, Vladimir Vukicevic said: > I'm confused -- it doesn't make them useless in practice, they can be > used exactly for what they're intended for (precompiled statements). > What exactly are you trying to do? And what other database supports > this? I misspoke. They

Re: [sqlite] Parameterized queries -- howto?

2004-10-20 Thread Vladimir Vukicevic
On Wed, 20 Oct 2004 17:19:47 -0700 (PDT), Ron Aaron <[EMAIL PROTECTED]> wrote: > On Wed, October 20, 2004 15:35, Vladimir Vukicevic said: > > No; there is no way to create a stored query only within sql; there's > > no place to actually store it. So using parameters doesn't really get > > you anyw

Re: [sqlite] Parameterized queries -- howto?

2004-10-20 Thread Ron Aaron
On Wed, October 20, 2004 15:35, Vladimir Vukicevic said: > On Wed, 20 Oct 2004 15:15:44 -0700 (PDT), Ron Aaron <[EMAIL PROTECTED]> wrote: >> Thanks. I know it can be done in the C API, that was not the question. The >> question was, can it be done *using SQL* ? > > No; there is no way to create

Re: [sqlite] Parameterized queries -- howto?

2004-10-20 Thread Vladimir Vukicevic
On Wed, 20 Oct 2004 15:15:44 -0700 (PDT), Ron Aaron <[EMAIL PROTECTED]> wrote: > Thanks. I know it can be done in the C API, that was not the question. The > question was, can it be done *using SQL* ? No; there is no way to create a stored query only within sql; there's no place to actually stor

Re: [sqlite] Parameterized queries -- howto?

2004-10-20 Thread Cory Nelson
insert into tbl values(?,?,?); then bind the parameters On Wed, 20 Oct 2004 15:15:44 -0700 (PDT), Ron Aaron <[EMAIL PROTECTED]> wrote: > > > > On Wed, October 20, 2004 14:57, Kurt Welgehausen said: > >> Am I missing something? > > > > Yes. Go to , click on , and > > read the C/C++ API Refere

Re: [sqlite] Parameterized queries -- howto?

2004-10-20 Thread Ron Aaron
On Wed, October 20, 2004 14:57, Kurt Welgehausen said: >> Am I missing something? > > Yes. Go to , click on , and > read the C/C++ API Reference. Thanks. I know it can be done in the C API, that was not the question. The question was, can it be done *using SQL* ? -- My GPG public key is at

Re: [sqlite] Parameterized queries -- howto?

2004-10-20 Thread Kurt Welgehausen
> Am I missing something? Yes. Go to , click on , and read the C/C++ API Reference. Regards

[sqlite] Parameterized queries -- howto?

2004-10-20 Thread Ron Aaron
I don't see any way to use parameterized queries from SQLite's version of SQL. Am I missing something? -- My GPG public key is at http://ronware.org/ fingerprint: 8130 734C 69A3 6542 0853 CB42 3ECF 9259 AD29 415D