Changeset 9f473ba for src/mvc/event.cpp
- Timestamp:
- 01/17/10 18:26:03 (13 years ago)
- Branches:
- master, qt5
- Children:
- 2af8e2f
- Parents:
- 6f39595
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
src/mvc/event.cpp
r6f39595 r9f473ba 30 30 { 31 31 QSqlQuery query; 32 query.prepare(selectQueryJoin2T("id") + "WHERE event.id = :id AND event.xid_conference = :conf"); 32 query.prepare( 33 selectQueryJoin2T("id") 34 + QString("WHERE %1.id = :id AND %1.xid_conference = :conf").arg(sTable1Name)); 33 35 query.bindValue(":id", id); 34 36 query.bindValue(":conf", conferenceId); … … 40 42 { 41 43 QSqlQuery query; 42 query.prepare(selectQueryJoin2T("id") + "WHERE event.xid_conference = :conf AND event.start >= :start AND event.start < :end ORDER BY event.start"); 44 query.prepare( 45 selectQueryJoin2T("id") 46 + QString("WHERE %1.xid_conference = :conf AND %1.start >= :start AND %1.start < :end ORDER BY %1.start").arg(sTable1Name)); 43 47 query.bindValue(":conf", conferenceId); 44 48 query.bindValue(":start", convertToDb(date, QVariant::DateTime)); … … 51 55 { 52 56 QSqlQuery query; 53 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"); 57 query.prepare( 58 selectQueryJoin2T("id") 59 + QString("WHERE %1.xid_conference = :conf AND %1.start >= :start AND %1.start < :end AND %1.favourite = 1 ORDER BY %1.start").arg(sTable1Name)); 54 60 query.bindValue(":conf", conferenceId); 55 61 query.bindValue(":start", convertToDb(date, QVariant::DateTime));
Note: See TracChangeset
for help on using the changeset viewer.