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异常,请问是什么原因?
解决方案 »
- explain一条sql语句好几百秒过去了没有反应。
- 请教高手--mysql插入大批量数据问题
- 检测MySql数据库的工具,大家一块讨论讨论
- Red Hat Linux下rpm安装mysql 出问题了,求高手
- 再求一个触发器
- Linux平台上我的Mysql启动不了了
- mysql 乱码的问题
- lock 的问题--回答立刻给分! 在线~~
- 求教这条SQL查询语句要怎么写
- 为什么我往MySQL数据库中保存文件,始终只要1M左右,数据好像被截断了?
- 求一SQL语句,标题里不太好说,要进来看看才知道
- MySQL报错:Lock wait timeout exceeded; try restarting transaction
你的SQL语句估计太长了!