[sqlite] bind with select?

[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",&fooval);
 sqlite_bind("?bar",&balval);

 while () { sqlite_step() 
                // foo and var bound to current values
        }

can someone point me to an example, or good documentation?



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------