bcb6 mysql5.0void TMain::InsertPhoto(int id, TJPEGImage *image)
{
char * p = NULL;
MYSQL_BIND bind[1];
unsigned long length;
MYSQL_STMT * stmt;
AnsiString sql = "Insert into `photo` (`member`,`photo`) values ("+AnsiString(id)+",?)";
stmt = mysql_stmt_init(mysql);
TMemoryStream * stream = new TMemoryStream();
stream->Position = 0;
image->SaveToStream(stream);
unsigned long psize = stream->Size;
p = new char [psize+1];
stream->Read(p,psize);
if(!stmt)
{
ShowMessage("Stmt failed to Create!");
}
if(mysql_stmt_prepare(stmt,sql.c_str(),sql.Length()))
{
ShowMessage(mysql_stmt_error(stmt));
}
memset(bind,0,sizeof(bind));
bind[0].buffer = p;
bind[0].buffer_type = MYSQL_TYPE_LONG_BLOB;
bind[0].is_null = 0;
if(mysql_stmt_bind_param(stmt,bind))
{
ShowMessage(mysql_stmt_error(stmt));
}
if(mysql_stmt_send_long_data(stmt,0,p,psize))
{
ShowMessage(mysql_stmt_error(stmt));
}
if(mysql_stmt_execute(stmt))
{
ShowMessage(mysql_stmt_error(stmt));
}
mysql_stmt_close(stmt);
delete p;
delete stream;
}运行时出现2035异常,请问是什么原因?
{
char * p = NULL;
MYSQL_BIND bind[1];
unsigned long length;
MYSQL_STMT * stmt;
AnsiString sql = "Insert into `photo` (`member`,`photo`) values ("+AnsiString(id)+",?)";
stmt = mysql_stmt_init(mysql);
TMemoryStream * stream = new TMemoryStream();
stream->Position = 0;
image->SaveToStream(stream);
unsigned long psize = stream->Size;
p = new char [psize+1];
stream->Read(p,psize);
if(!stmt)
{
ShowMessage("Stmt failed to Create!");
}
if(mysql_stmt_prepare(stmt,sql.c_str(),sql.Length()))
{
ShowMessage(mysql_stmt_error(stmt));
}
memset(bind,0,sizeof(bind));
bind[0].buffer = p;
bind[0].buffer_type = MYSQL_TYPE_LONG_BLOB;
bind[0].is_null = 0;
if(mysql_stmt_bind_param(stmt,bind))
{
ShowMessage(mysql_stmt_error(stmt));
}
if(mysql_stmt_send_long_data(stmt,0,p,psize))
{
ShowMessage(mysql_stmt_error(stmt));
}
if(mysql_stmt_execute(stmt))
{
ShowMessage(mysql_stmt_error(stmt));
}
mysql_stmt_close(stmt);
delete p;
delete stream;
}运行时出现2035异常,请问是什么原因?
解决方案 »
- mysql中的newInstance()
- 我有一个mysql 的数据库 请给我专成access的 100元 可以吗 在线等
- mysql字串 截取:如何从字串右边第一个“_”截取不定长度的字串
- 关于mysql的版本5.0到5.1的问题!
- postgresql 导入.sql文件
- 请问一个mysql连接的问题。
- 用程序连接mysql数据库的奇怪问题
- 关于在IIS下mysql查询时现的奇怪现象,各位老大救命啊!
- 我用MYSQL做在线人数调查
- MySQL 一张表合并查询
- 求一SQL语句,标题里不太好说,要进来看看才知道
- MySQL报错:Lock wait timeout exceeded; try restarting transaction
你的SQL语句估计太长了!