f-spot r4508 - trunk/src

[sdelcroix svn gnome org]

Author: sdelcroix
Date: Fri Oct 17 11:51:15 2008
New Revision: 4508
URL: http://svn.gnome.org/viewvc/f-spot?rev=4508&view=rev

Log:
fix column names for ROWID

Modified:
   trunk/src/PhotoStore.cs

Modified: trunk/src/PhotoStore.cs
==============================================================================
--- trunk/src/PhotoStore.cs	(original)
+++ trunk/src/PhotoStore.cs	Fri Oct 17 11:51:15 2008
@@ -705,7 +705,7 @@
 
 	public int [] IndicesOf (string table_name, uint [] items)
 	{
-		StringBuilder query_builder = new StringBuilder ("SELECT ROWID FROM ");
+		StringBuilder query_builder = new StringBuilder ("SELECT ROWID AS row_id FROM ");
 		query_builder.Append (table_name);
 		query_builder.Append (" WHERE id IN (");
 		for (int i = 0; i < items.Length; i++) {
@@ -723,7 +723,7 @@
 
 	public int IndexOf (string table_name, DateTime time, bool asc)
 	{
-		string query = String.Format ("SELECT ROWID FROM {0} WHERE time {2} {1} ORDER BY time {3} LIMIT 1",
+		string query = String.Format ("SELECT ROWID AS row_id FROM {0} WHERE time {2} {1} ORDER BY time {3} LIMIT 1",
 				table_name,
 				DbUtils.UnixTimeFromDateTime (time),
 				asc ? ">=" : "<=",