.:: Bots United ::. - mySQL + HPB

.:: Bots United ::. (http://forums.bots-united.com/index.php)

- General Bot Coding (http://forums.bots-united.com/forumdisplay.php?f=24)

- - mySQL + HPB_bot (http://forums.bots-united.com/showthread.php?t=5994)

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

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?

Re: mySQL + HPB_bot

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