iphone - sqlite insert putting values into wrong fields -
i'm trying insert this - (void)insertblogstory:(nsstring *)storytitle link:(nsstring *)link storydescription:(nsstring *)storydescription storyhtml:(nsstring *)storyhtml pubdate:(nsstring *)pubdate blog:(nsstring *)blog { nslog(@"storytitle %@",storytitle); nslog(@"link %@",link); nslog(@"storydescription %@",storydescription); nslog(@"storyhtml %@",storyhtml); nslog(@"pubdate %@",pubdate); nslog(@"blog %@",blog); if(addstmt == nil) { const char *sql = "insert contents (storytitle, link, storydescription, storyhtml, pubdate, blog, read) values (?, ?, ?, ?, ?, ?, ?)"; if(sqlite3_prepare_v2(_database, sql, -1, &addstmt, null) != sqlite_ok) nsassert1(0, @"error while creating add statement. '%s'", sqlite3_errmsg(_database)); } sqlite3_bind_text(addstmt, 1, [storytitle utf8string], -1, sqlite_transient); sqlite3_