Titanium sqlite ORDER BY statement
Titanium sqlite ORDER BY statement
使用Titanium appcelerator。如何使用单击按钮激活的sql查询对数据库进行排序。到目前为止,我的代码是:
SortButton.addEventListener('click',function(e){
sortList();
});
function sortList()
{
db.execute("SELECT * FROM SavedList ORDER BY SavedListed ASC");
}
您的代码:db.execute("SELECT*FROM SavedList ORDER BY SavedListed ASC");是正确的。只需在db.execute之前打开数据库,在db.eexecute之后关闭它。它会起作用的。
要打开数据库,请执行以下操作:var db=Ti.Database.open('databaseName');
要关闭数据库,请执行以下操作:db.close();
相关文章:
- getDocument by id/get input text from button dons'不起作用
- Div and ul list side by side
- Jquery else if statement
- javascript "or" statement
- Rails 3 if statement with jQuery?
- TinySort sort by IDs
- JQuery Else if statement?
- 在jQuery .load Ajax之后执行if-statement
- Two input forms side-by-side programatically via JavaScript
- ngRepeat filter by array-property
- SQL应该查询's ORDER BY列写入JS代码中
- Javascript if statement if (ball.style.left === '0px'
- 有没有办法缩短Require.js's require statement?我是不是误解了怎么用它
- jQuery如何显示/隐藏Select by Select
- How efficient is the "with" statement?
- angularjs:自定义直接中的绑定数据在使用“”后不再更新;track-by-;在ng重复中
- jquery increase by 1
- Angular edit by clicking on a tr
- Vue.js"track-by-$index”;,如何单独呈现列表项
- Titanium sqlite ORDER BY statement