我正在使用cordova 1.9开发一个phonegap应用程序
我在这个语句上有一个语法错误:
db.executeSql('UPDATE Reminder SET Reminder.reminderName ="'+ reminder_name + '", Reminder.reminderDescription = "' + description +'", Reminder.cellId='+ 1 +', Reminder.timetableId ='+1+', Reminder.reminderDeadline ="' + deadline +'" WHERE Reminder.RminId = "'+reminderId+'" ');
所以,我想知道我做错了什么?
您的1可能有问题。
在输入1的地方,你应该把它放在一个变量中,或者去掉引号:
db.executeSql('UPDATE Reminder SET Reminder.reminderName ="'+ reminder_name + '", Reminder.reminderDescription = "' + description +'", Reminder.cellId=1, Reminder.timetableId =1, Reminder.reminderDeadline ="' + deadline +'" WHERE Reminder.RminId = "'+reminderId+'" ');
或
var cellID = 1;
var timetableID = 1;
db.executeSql('UPDATE Reminder SET Reminder.reminderName ="'+ reminder_name + '", Reminder.reminderDescription = "' + description +'", Reminder.cellId='+ cellID +', Reminder.timetableId ='+timetableID+', Reminder.reminderDeadline ="' + deadline +'" WHERE Reminder.RminId = "'+reminderId+'" ');
看起来你的单引号和双引号错误且混乱
试试这个:
db.executeSql("UPDATE Reminder SET Reminder.reminderName = "
+ reminder_name + ", Reminder.reminderDescription = "
+ description + ", Reminder.cellId = " + 1
+ ", Reminder.timetableId = " + 1
+ ", Reminder.reminderDeadline = " + deadline
+ " WHERE Reminder.RminId = " + reminderId + " ");