Changeset 9f473ba for src/mvc/event.cpp

Timestamp:

01/17/10 18:26:03 (13 years ago)

Author:

pavelpa <pavelpa@…>

Branches:

master, qt5

Children:

2af8e2f

Parents:

6f39595

Message:

just minor corrections to 'event'

File:

• src/mvc/event.cpp (modified) (3 diffs)

src/mvc/event.cpp

@@ -30 +30 @@
 {
     QSqlQuery query;
-    query.prepare(selectQueryJoin2T("id") + "WHERE event.id = :id AND event.xid_conference = :conf");
+    query.prepare(
+            selectQueryJoin2T("id")
+            + QString("WHERE %1.id = :id AND %1.xid_conference = :conf").arg(sTable1Name));
     query.bindValue(":id", id);
     query.bindValue(":conf", conferenceId);
@@ -40 +42 @@
 {
     QSqlQuery query;
-    query.prepare(selectQueryJoin2T("id") + "WHERE event.xid_conference = :conf AND event.start >= :start AND event.start < :end ORDER BY event.start");
+    query.prepare(
+            selectQueryJoin2T("id")
+            + QString("WHERE %1.xid_conference = :conf AND %1.start >= :start AND %1.start < :end ORDER BY %1.start").arg(sTable1Name));
     query.bindValue(":conf", conferenceId);
     query.bindValue(":start", convertToDb(date, QVariant::DateTime));
@@ -51 +55 @@
 {
     QSqlQuery query;
-    query.prepare(selectQueryJoin2T("id") + "WHERE event.xid_conference = :conf AND event.start >= :start AND event.start < :end AND event.favourite = 1 ORDER BY event.start");
+    query.prepare(
+            selectQueryJoin2T("id")
+            + QString("WHERE %1.xid_conference = :conf AND %1.start >= :start AND %1.start < :end AND %1.favourite = 1 ORDER BY %1.start").arg(sTable1Name));
     query.bindValue(":conf", conferenceId);
     query.bindValue(":start", convertToDb(date, QVariant::DateTime));