Re: Connector/C++ v 8 and binding parameters

[Luis Silva]

Hi Walter,

For binding, you need to do it using prepared statements:

For :
create table newtable(f0 int, f1 varchar(1024));

insert into newtable VALUES(1,"1");
insert into newtable VALUES(2,"2");
insert into newtable VALUES(3,"3");


Code:

sql::PreparedStatement *pstmt = conn->prepareStatement("select f1 from newtable where f0 > ? ");

//Bind position (starts in 1)
pstmt->setInt(1, 1);

sql::ResultSet *res = pstmt->executeQuery();

Hope it helps!

Cheers,
Luís