[chronojump] Fixed SqliteJump.SelectDJa query



commit 45bb68080a16bea366c6872b98c6e1b60246d541
Author: Xavier de Blas <xaviblas gmail com>
Date:   Fri Dec 13 18:41:20 2019 +0100

    Fixed SqliteJump.SelectDJa query

 src/sqlite/jump.cs | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)
---
diff --git a/src/sqlite/jump.cs b/src/sqlite/jump.cs
index 725ab481..e4949cfc 100644
--- a/src/sqlite/jump.cs
+++ b/src/sqlite/jump.cs
@@ -337,15 +337,13 @@ class SqliteJump : Sqlite
        {
          string personID = pID.ToString();
          string sessionID = sID.ToString();
-         string tps = Constants.PersonSessionTable;
 
          Sqlite.Open();
 
          // Selecciona les dades de tots els salts
          dbcmd.CommandText = "SELECT " + "jump.*" +
-         " FROM " + "jump, " + tps +
-         " WHERE " + tps + ".personID = " + personID + " AND " + tps + 
-         ".sessionID = " + sessionID  +  " AND jump.type = \"DJa\" ";
+         " FROM " + "jump WHERE personID = " + personID +
+         " AND sessionID = " + sessionID  +  " AND jump.type = \"DJa\" ";
 
          LogB.SQL(dbcmd.CommandText.ToString());
          dbcmd.ExecuteNonQuery();


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