[freetds] prepared statements in db-lib

Andrew H. Wakefield a_wake at earthlink.net
Sun Feb 21 14:27:26 EST 2010


I have been playing with db-lib, and find it to be a very nice
interface. But there is one thing that I seem to be missing, and can't
figure out -- does it not have any way to do a "prepared statement" --
IOW, a statement with parameters that are filled in before execution --
other than as an actual stored procedure?

Here's what I want to be able to do, in a mixture of sql and
pseudo-code:

sql_statement: INSERT INTO test_tbl VALUES ( ?, ?, ? );
set_param(1, 52)
set_param(2, 'Testing')
set_param(3, 123.456)
execute prepared statement

If db-lib cannot do this, can ct-lib? Or do I have to go down to the
libtds layer?

Many thanks ...


Andy Wakefield
a_wake at earthlink.net 

On Mon, 2010-01-11 at 21:55 -0500, James K. Lowden wrote:

> Andrew H. Wakefield wrote:
> > I
> > downloaded the "nightly snapshot" yesterday and tried to cross-compile
> > for Windows. It failed during the make, using the settings that worked
> > successfully for freetds-0.82. IIRC, the error had something to do with
> > types.h inclusion.
> 
> Tonight's version should be better.  Let us know.  
> 
> --jkl



More information about the FreeTDS mailing list