[chronojump] Fixed SqliteJump.SelectDJa query
- From: Xavier de Blas <xaviblas src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [chronojump] Fixed SqliteJump.SelectDJa query
- Date: Fri, 13 Dec 2019 17:45:34 +0000 (UTC)
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]