Re: [sqlite] Retrieve bound host parameters from statement?

2007-10-30 Thread Kees Nuyt
On Tue, 30 Oct 2007 17:28:35 +0700, Dan Kennedy <[EMAIL PROTECTED]> wrote: >... >Say you want to query statement object >X that has 4 variables, you could do this: > > pTmp = sqlite3_prepare("SELECT ?, ?, ?, ?"); > sqlite3_transfer_bindings(X, pTmp); > /* Use sqlite3_step() etc. to fish values

Re: [sqlite] Retrieve bound host parameters from statement?

2007-10-30 Thread Joe Wilson
--- Dennis Cote <[EMAIL PROTECTED]> wrote: > Joe Wilson wrote: > > The transferred bindings are still opaque, aren't they? > > > > --- Dan Kennedy <[EMAIL PROTECTED]> wrote: > > > >> Depends how desperate you are. Say you want to query statement > >> object X that has 4 variables, you could do

Re: [sqlite] Retrieve bound host parameters from statement?

2007-10-30 Thread Dennis Cote
Joe Wilson wrote: The transferred bindings are still opaque, aren't they? --- Dan Kennedy <[EMAIL PROTECTED]> wrote: Depends how desperate you are. Say you want to query statement object X that has 4 variables, you could do this: pTmp = sqlite3_prepare("SELECT ?, ?, ?, ?");

Re: [sqlite] Retrieve bound host parameters from statement?

2007-10-30 Thread Joe Wilson
The transferred bindings are still opaque, aren't they? --- Dan Kennedy <[EMAIL PROTECTED]> wrote: > Depends how desperate you are. Say you want to query statement > object X that has 4 variables, you could do this: > > pTmp = sqlite3_prepare("SELECT ?, ?, ?, ?"); >

Re: [sqlite] Retrieve bound host parameters from statement?

2007-10-30 Thread Ralf Junker
Hello Joe Wilson, >> True, but we would need to access unsupported API to do so. And as we know >> only too well, >> unsupported API is subject to change without notice any time ;-). Therefore >> I would rather not >> write these myself but ask for the possibility to add them to the library >>

Re: [sqlite] Retrieve bound host parameters from statement?

2007-10-30 Thread Ralf Junker
Hello Dan Kennedy, >> True, but we would need to access unsupported API to do so. >> And as we know only too well, unsupported API is subject to >> change without notice any time ;-). Therefore I would rather >> not write these myself but ask for the possibility to add them >> to the library

Re: [sqlite] Retrieve bound host parameters from statement?

2007-10-30 Thread Dan Kennedy
On Mon, 2007-10-29 at 17:49 +0100, Ralf Junker wrote: > >> I wonder if it is possible to retrieve bound host parameters from a > >> prepared SQL statement? I am > >> thinking of the opposite of the sqlite3_bind... family of functions like: > >> > >> int sqlite3_bound_int (sqlite3_stmt*, int*);

Re: [sqlite] Retrieve bound host parameters from statement?

2007-10-29 Thread Ralf Junker
>> I wonder if it is possible to retrieve bound host parameters from a prepared >> SQL statement? I am >> thinking of the opposite of the sqlite3_bind... family of functions like: >> >> int sqlite3_bound_int (sqlite3_stmt*, int*); >> int sqlite3_bound_double (sqlite3_stmt*, double*); >

Re: [sqlite] Retrieve bound host parameters from statement?

2007-10-29 Thread Joe Wilson
--- Ralf Junker <[EMAIL PROTECTED]> wrote: > I wonder if it is possible to retrieve bound host parameters from a prepared > SQL statement? I am > thinking of the opposite of the sqlite3_bind... family of functions like: > > int sqlite3_bound_int (sqlite3_stmt*, int*); > int

[sqlite] Retrieve bound host parameters from statement?

2007-10-29 Thread Ralf Junker
Hello, I wonder if it is possible to retrieve bound host parameters from a prepared SQL statement? I am thinking of the opposite of the sqlite3_bind... family of functions like: int sqlite3_bound_int (sqlite3_stmt*, int*); int sqlite3_bound_double (sqlite3_stmt*, double*); They would be