往数据表插入数据不成功

Cocos2d-x Lua
#1

local id = row"id"]
local user_id = row"user_id"]
local cate_id = row"cate_id"]
local like_times = row"like_times"]
local is_collect = row"is_collect"]
local createdAt = row"createdAt"]
local updatedAt = row"updatedAt"]
local word = row"word"]
local played_times = 0
self:executeSQL(“INSERT INTO game_punish_rank_words(id,word,is_collect,like_times, played_times) values(‘id’,‘word’,‘is_collect’,‘like_times’, ‘played_times’)”)
效果如图。
如果values 不加单引号，提示no column id
如何正确的传入数据？

#2

这个和quick无关了，请对照sql的语法进行检查吧

#3

“INSERT INTO game_punish_rank_words(id,word,is_collect,like_times, played_times) values(‘id’,‘word’,‘is_collect’,‘like_times’, ‘played_times’)”

game_punish_rank_words (id,
values ('id
这个括号之间你加个空格看看。。。

#4

local id = row"id"]
local like_times = row"like_times"]
local is_collect = 0
local word = “’”…row"word"]…"’"
local played_times = 0
local sqlfront = “INSERT INTO game_punish_rank_words (id,word,is_collect,like_times,played_times) values "
local sqlback = “(”…table.concat({id,word,is_collect,like_times,played_times},”,")…")"
luaLog(sqlfront…sqlback)
self:executeSQL(sqlfront…sqlback)
可以解决，
我要自问自答吗？

#5

— Begin quote from ____

引用第3楼yangjing_hit于2014-08-28 14:25发表的 :
local id = row"id"]
local like_times = row"like_times"]
local is_collect = 0
local word = “’”…row"word"]…"’"
local played_times = 0
… http://www.cocoachina.com/bbs/job.php?action=topost&tid=226074&pid=1040972

— End quote

你用的哪个版本？quick已经集成sqlite了吗？