+ // Get a notebook's sort order\r
+ public int getSortColumn(String guid) {\r
+ boolean check;\r
+ \r
+ NSqlQuery query = new NSqlQuery(db.getConnection());\r
+ \r
+ if (Global.getSortOrder() != Global.View_List_Wide)\r
+ check = query.prepare("Select wide_sort_column " \r
+ +"from "+dbName+" where guid=:guid");\r
+ else\r
+ check = query.prepare("Select narrow_sort_column " \r
+ +"from "+dbName+" where guid=:guid");\r
+ query.bindValue(":guid", guid);\r
+ check = query.exec();\r
+ if (!check) {\r
+ logger.log(logger.EXTREME, "Notebook SQL retrieve sort order has failed.");\r
+ return -1;\r
+ }\r
+ if (query.next()) {\r
+ return query.valueInteger(0);\r
+ } \r
+ return -1;\r
+ } \r
+\r
+ // Get a notebook's sort order\r
+ public int getSortOrder(String guid) {\r
+ boolean check;\r
+ \r
+ NSqlQuery query = new NSqlQuery(db.getConnection());\r
+ \r
+ if (Global.getSortOrder() != Global.View_List_Wide)\r
+ check = query.prepare("Select wide_sort_order " \r
+ +"from "+dbName+" where guid=:guid");\r
+ else\r
+ check = query.prepare("Select narrow_sort_order " \r
+ +"from "+dbName+" where guid=:guid");\r
+ query.bindValue(":guid", guid);\r
+ check = query.exec();\r
+ if (!check) {\r
+ logger.log(logger.EXTREME, "Notebook SQL retrieve sort order has failed.");\r
+ return -1;\r
+ }\r
+ if (query.next()) {\r
+ return query.valueInteger(0);\r
+ } \r
+ return -1;\r
+ } \r
+ // Get a notebook's sort order\r
+ public void setSortOrder(String guid, int column, int order) {\r
+ boolean check;\r
+ \r
+ NSqlQuery query = new NSqlQuery(db.getConnection());\r
+ \r
+ if (Global.getSortOrder() != Global.View_List_Wide)\r
+ check = query.prepare("Update "+dbName+" set wide_sort_order=:order, wide_sort_column=:column where guid=:guid");\r
+ else\r
+ check = query.prepare("Update "+dbName+" set narrow_sort_order=:order, narrow_sort_column=:column where guid=:guid");\r
+\r
+ query.bindValue(":guid", guid);\r
+ query.bindValue(":order", order);\r
+ query.bindValue(":column", column);\r
+ check = query.exec();\r
+ if (!check)\r
+ logger.log(logger.EXTREME, "Notebook SQL set sort order has failed.");\r
+ } \r