开发者

How to save the image into sqlite database?

iam developing one application.In that i plce the images in 3 views.And first 2 views are worked well.But in third view images are not saved in database.Below one is my code for updating the images.

-(void)updateStaff:(DataBaseFields*)databasefields
{
if(stfupdateStmt == nil) {
    const char *sql = "update FoodBlogger Set update_date_time = ?, Stf_Mgr_Image = ?, Stf_Mgr_Text = ?, Stf_Srvr_Image = ?, Stf_Chf_Image = ?, Stf_Owr_Image= ? Where insert_date_time = ?";
    if(sqlite3_prepare_v2(database, sql, -1, &stfupdateStmt, NULL) != SQLITE_OK) 
        NSAssert1(0, @"Error while creating update statement. '%s'", sqlite3_errmsg(database));
}

sqlite3_bind_text(stfupdateStmt, 1, [databasefields.update_datetime UTF8String], -1, SQLITE_TRANSIENT);

sqlite3_bind_blob(stfupdateStmt, 2, [databasefields.mgrImage bytes], [databasefields.mgrImage length], SQLITE_TRANSIENT);

sqlite3_bind_blob(stfupdateStmt, 3, [databasefields.srvrImage bytes], [databasefields.srvrImage length], SQLITE_TRANSIENT);

sqlite3_bind_blob(stfupdateStmt, 4, [databasefields.chfImage bytes], [databasefields.chfImage length], SQLITE_TRANSIENT);

sqlite3_bind_blob(stfupdateStmt, 5, [databasefields.owrImage bytes], [databasefields.owrImage length], SQLITE_TRANSIENT);

sqlite3_bind_text(stfupdateStmt, 6, [databasefields.insert_datetime UTF8Stri开发者_开发技巧ng], -1, SQLITE_TRANSIENT);

if(SQLITE_DONE != sqlite3_step(stfupdateStmt))
    NSAssert1(0, @"Error while updating. '%s'", sqlite3_errmsg(database));

sqlite3_reset(stfupdateStmt);

}

And image varaible in database type is varchar.Before 2 views are worked correctly.But this view was not working.So please help me how to solve this one.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜