在sqlite中执行查询时出现未定义的错误 [英] Getting undefined error while executing the query in sqlite
问题描述
我需要在将数据插入表格之前检查sqlite中的重复项目。我需要检查它是否已经存在。我有一个创建表格。
tx.executeSql('CREATE TABLE IF NOT NOT EXISTS CaseTable(id INTEGER PRIMARY KEY AUTOINCREMENT,CaseName TEXT NOT NULL UNIQUE,CaseDate INTEGER,TextArea TEXT NOT NULL)');
$(document).on('click','#addButton',function(){
checkExitingFolderName() ;
insertData();
}
});
函数checkExitingFolderName(){
db.transaction(getallTableCntend,errorCB);
}
函数getallTableCntend(tx){
var str = tx.executeSql('SELECT 1 FROM CaseTable WHERE CaseName ='+ $('。caseName_h')。val());
alert(str+ str);
}
(文档) .on('click','#AddButton',function(){
checkExitingFolderName();
insertData();
}
});
function checkExitingFolderName(){
db.transaction(getallTableCntend,errorCB);
}
函数getallTableCntend( tx){
var str = tx.executeSql('SELECT 1 FROM CaseTable WHERE CaseName ='+
('。caseName_h')。val()) ;
alert(str+ str);
}
我做完了..使用unique和insert或ignore关键字
I need to check duplicate item in sqlite before inserting the data in table .I need to check whether it already present or not .I have a create a table.
tx.executeSql('CREATE TABLE IF NOT EXISTS CaseTable (id INTEGER PRIMARY KEY AUTOINCREMENT, CaseName TEXT NOT NULL UNIQUE,CaseDate INTEGER ,TextArea TEXT NOT NULL)');
$(document).on('click', '#AddButton', function() {
checkExitingFolderName();
insertData();
}
});
function checkExitingFolderName(){
db.transaction(getallTableCntend, errorCB);
}
function getallTableCntend(tx) {
var str=tx.executeSql('SELECT 1 FROM CaseTable WHERE CaseName ='+$('.caseName_h').val());
alert("str"+str);
}
(document).on('click', '#AddButton', function() {
checkExitingFolderName();
insertData();
}
});
function checkExitingFolderName(){
db.transaction(getallTableCntend, errorCB);
}
function getallTableCntend(tx) {
var str=tx.executeSql('SELECT 1 FROM CaseTable WHERE CaseName ='+
('.caseName_h').val());
alert("str"+str);
}
i done it..using unique and insert or ignore keyword
这篇关于在sqlite中执行查询时出现未定义的错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!