本文是小编为大家收集整理的关于Titanium sqlite ORDER BY 语句的处理/解决方法，可以参考本文帮助大家快速定位并解决问题，中文翻译不准确的可切换到English标签页查看源文。
问题描述
使用钛appcelerator.如何使用单击按钮上激活的SQL查询对数据库进行排序.到目前为止，我的代码是:
SortButton.addEventListener('click',function(e){
sortList();
});
function sortList()
{
db.execute("SELECT * FROM SavedList ORDER BY SavedListed ASC");
}
推荐答案
您的代码:db.execute("从savedlist asce savedlisted asc select *从savedlist订单中进行选择");是正确的.只需在db.ectute之前打开数据库，然后在db.execute之后关闭.它将起作用.
打开数据库: var db = ti.database.open('databasename');
关闭数据库: db.close();
问题描述
Using Titanium appcelerator. How can i sort my database with an sql query which is activated on a button click. my code so far is:
SortButton.addEventListener('click',function(e){
sortList();
});
function sortList()
{
db.execute("SELECT * FROM SavedList ORDER BY SavedListed ASC");
}
推荐答案
Your code : db.execute("SELECT * FROM SavedList ORDER BY SavedListed ASC"); is correct. Just open database before db.execute and close it after db.execute. It will work.
To open database : var db = Ti.Database.open('databaseName');
To close database: db.close();
更多相关问答
联系站长