[f-spot] Correctly capitalize SQL keywords.



commit f7b5311d8a0b25532030fb0da6ef1ed8f9df279b
Author: Ruben Vermeersch <ruben savanne be>
Date:   Fri May 14 19:30:17 2010 +0200

    Correctly capitalize SQL keywords.

 src/PhotoStore.cs |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)
---
diff --git a/src/PhotoStore.cs b/src/PhotoStore.cs
index a6c2b69..550a5f3 100644
--- a/src/PhotoStore.cs
+++ b/src/PhotoStore.cs
@@ -236,7 +236,7 @@ public class PhotoStore : DbStore<Photo> {
 	}		
 	
 	private void GetAllVersions  (string ids) {
-		SqliteDataReader reader = Database.Query ("SELECT photo_id, version_id, name, base_uri, filename, md5_sum, protected FROM photo_versions WHERE photo_id in " + ids);
+		SqliteDataReader reader = Database.Query ("SELECT photo_id, version_id, name, base_uri, filename, md5_sum, protected FROM photo_versions WHERE photo_id IN " + ids);
 		
 		while (reader.Read ()) {
 			uint id = Convert.ToUInt32 (reader ["photo_id"]);
@@ -273,7 +273,7 @@ public class PhotoStore : DbStore<Photo> {
 	}
 
 	private void GetAllTags (string ids) {
-		SqliteDataReader reader = Database.Query ("SELECT photo_id, tag_id FROM photo_tags WHERE photo_id in " + ids);
+		SqliteDataReader reader = Database.Query ("SELECT photo_id, tag_id FROM photo_tags WHERE photo_id IN " + ids);
 
 		while (reader.Read ()) {
 			uint id = Convert.ToUInt32 (reader ["photo_id"]);



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]