Fix translations directory to match source and fix note title sql problem.

diff --git a/src/cx/fbn/nevernote/config/FileManager.java b/src/cx/fbn/nevernote/config/FileManager.java
index cff1b21..73c1054 100644 (file)
--- a/src/cx/fbn/nevernote/config/FileManager.java
+++ b/src/cx/fbn/nevernote/config/FileManager.java
@@ -77,7 +77,7 @@ public class FileManager {
         xmlDir = new File(programDir, "xml");
         checkExistingReadableDir(xmlDir);
 
-        translateDir = new File(programDir, "translate");
+        translateDir = new File(programDir, "translations");
         checkExistingReadableDir(translateDir);
         translateDirPath= slashTerminatePath(translateDir.getPath());
 

diff --git a/src/cx/fbn/nevernote/sql/NoteTable.java b/src/cx/fbn/nevernote/sql/NoteTable.java
index 4f89d08..0269fdb 100644 (file)
--- a/src/cx/fbn/nevernote/sql/NoteTable.java
+++ b/src/cx/fbn/nevernote/sql/NoteTable.java
@@ -1022,7 +1022,9 @@ public class NoteTable {
                List<Pair<String,Integer>> returnValue = new ArrayList<Pair<String,Integer>>();\r
         NSqlQuery query = new NSqlQuery(db.getConnection());\r
                \r
-               if (!query.exec("Select titleColor from Note where titleColor != -1 and guid=:guid"))\r
+        query.prepare("Select titleColor from Note where titleColor != -1 and guid=:guid");\r
+        query.bindValue(":guid", guid);\r
+               if (!query.exec())\r
                        logger.log(logger.EXTREME, "Note SQL retrieve has failed on getNoteTitleColor(guid).");\r
 \r
                Integer color = -1;\r