ios - 从 touch 删除坐标时出错。 'near ",": syntax error' '

Question

我有 UIWebView 用于显示 HTML 文章页面。我使用 UILongPressGesture 获取触摸位置坐标。我将这些坐标保存到数据库中。每个坐标都有按钮。现在我需要在单击按钮时从数据库中删除这些坐标之一。所以，在这里我从数据库中获取坐标并且坐标与当前位置匹配然后我删除特定的坐标按钮。但它并没有删除

 if(x1 && y1){

        NSLog(@"x1 is %f",x1);
        NSLog(@"y1 is %f",y1);


        sqlite3_stmt *addStmt;

       // const char *sqlDelete = "DELETE xcoor,ycoor FROM touch";


         const char *sqlDelete = [[NSString stringWithFormat:@"delete FROM touch where xcoor = '%f','%f'",x1,y1] cStringUsingEncoding:NSUTF8StringEncoding];

        if(sqlite3_prepare_v2(database, sqlDelete, -1, &addStmt, NULL) != SQLITE_OK)
            NSAssert1(0, @"Error while deleting coor from touch . '%s'", sqlite3_errmsg(database));

        NSLog(@"%s error finalizing %s", __FUNCTION__, sqlite3_errmsg(database));

        if(SQLITE_DONE != sqlite3_step(addStmt))
            NSAssert1(0, @"Error while deleting coor from touch . '%s'", sqlite3_errmsg(database));


}

x1 & y1为当前位置坐标

Answer 1

const char *sqlDelete = [[NSString stringWithFormat:@"delete FROM touch where xcoor = %f AND ycoor = %f",x1,y1] cStringUsingEncoding:NSUTF8StringEncoding];

用这个替换你的删除语句就可以了