From 58871d54f8ecaf9bde0689edb58561f40ed0f683 Mon Sep 17 00:00:00 2001
From: Eugenio Favalli <elvenprogrammer@gmail.com>
Date: Mon, 9 Jan 2006 13:42:46 +0000
Subject: Fixed some sql query issues

---
 src/dalstorage.cpp | 15 ++++++++-------
 1 file changed, 8 insertions(+), 7 deletions(-)

diff --git a/src/dalstorage.cpp b/src/dalstorage.cpp
index eeb6249d..fc168925 100644
--- a/src/dalstorage.cpp
+++ b/src/dalstorage.cpp
@@ -491,13 +491,14 @@ DALStorage::getMapNameFromId(const unsigned int mapId)
     open();
 
     try {
-        std::string sql("select map from ");
-        sql += MAPS_TBL_NAME;
-        sql += " where id = '";
-        sql += mapId;
-        sql += "');";
-
-        const dal::RecordSet& mapInfo = mDb->execSql(sql);
+        std::stringstream sql;
+        sql << "select map from ";
+        sql << MAPS_TBL_NAME;
+        sql << " where id = ";
+        sql << mapId;
+        sql << ";";
+        
+        const dal::RecordSet& mapInfo = mDb->execSql(sql.str());
 
         // If the map return is empty then we have no choice but to return false.
         if (mapInfo.isEmpty()) {
-- 
cgit v1.2.3-60-g2f50