Re: [sqlite] bind with select?

2006-10-20 Thread Jay Sprenkle
On 10/16/06, Dave Dyer <[EMAIL PROTECTED]> wrote: I can't find an example, but it seems like there ought to be syntax to use bind to inline selection variables, instead of having to have a callback function. Something like: char *forval,*barval; sqlite_prepare(db,"select ?foo,?bar from

Re: [sqlite] bind with select?

2006-10-17 Thread Dennis Cote
Dave Dyer wrote: I can't find an example, but it seems like there ought to be syntax to use bind to inline selection variables, instead of having to have a callback function. Something like: char *forval,*barval; sqlite_prepare(db,"select ?foo,?bar from table"); sqlite_bind("?foo",);

[sqlite] bind with select?

2006-10-16 Thread Dave Dyer
I can't find an example, but it seems like there ought to be syntax to use bind to inline selection variables, instead of having to have a callback function. Something like: char *forval,*barval; sqlite_prepare(db,"select ?foo,?bar from table"); sqlite_bind("?foo",); sqlite_bind("?bar",);