mySQL + HPB_bot

[RedLink]

Well I've been trying to integrate MySQL++ into HPB_bot, thou I've got a major problem. I've succeeded to connect to my SQL database thou any attempt to fetch or insert information results in a crash.

Sample code

mysqlpp::Connection con("test","127.0.0.1","test","test");
mysqlpp::Query query = con.query();
...
sprintf( buff, "INSERT INTO chat (id,message,date) VALUES('','%s','NOW()')\0",szMsg_buff);
...
mysqlpp::Result res = query.store(buff)

I'm guessing I'll haft to make a separate thread, is there a way to get past this obstacle as smooth as possible?

[Cheeseh]

you should ALWAYS try and catch for SQL Exceptions when using SQL. As the sql command will likely contain syntax errors and the only way to know there is a syntax error is to raise an exception. If the exception is not handled (handled = using try and catch), the program will crash.

see: http://tangentsoft.net/mysql++/doc/u.../tutorial.html