Problem with prepared statement

[crashtua]

I have following code:

Code: Select all

Statement stmt(*_pSession);
stmt << "INSERT INTO admins (botid,name,server) VALUES(:botid, :name, :server)", use(0), use("crashtua"), use("war3.alkar.net");


But it gives me

[Comment]: mysql_stmt_prepare error [mysql_stmt_error]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':botid, :name, :server)' at line 1 [mysql_stmt_errno]: 1064 [mysql_stmt_sqlstate]: 42000 [statemnt]: INSERT INTO admins (botid,name,server) VALUES(:botid, :name, :server)

What is wrong with statement?

[crashtua]

Changed

VALUES(:botid, :name, :server)

on

VALUES(?, ?, ?)

But it gives unhandled exception on

Code: Select all

void StatementImpl::bind()
{
   if (_state == ST_COMPILED)
   {
      bindImpl();


[alex]

Hard to tell without knowing more about what exactly are you doing, which POCO version you are using and where exactly is the exception thrown. Try this:

Code: Select all

Statement stmt(*_pSession);
std::string s1("crashtua"), s2("war3.alkar.net");
stmt << "INSERT INTO admins (botid,name,server) VALUES(:botid, :name, :server)", use(0), use(s1), use(s2);

and make sure s1 and s2 are available at the point where you are executing it.

[crashtua]

Code: Select all

std::string s1("crashtua"), s2("war3.alkar.net");


and make sure s1 and s2 are available at the point where you are executing it.

Thats was the reason... use() with char array does not work... That's all right, but it cost me a lot of time... Thanks a lot!
how c++ is difficult after years of java:)