Changeset 9f473ba for src/mvc/event.cpp


Ignore:
Timestamp:
01/17/10 18:26:03 (12 years ago)
Author:
pavelpa <pavelpa@…>
Branches:
master, qt5
Children:
2af8e2f
Parents:
6f39595
Message:

just minor corrections to 'event'

File:
1 edited

Legend:

Unmodified
Added
Removed
  • src/mvc/event.cpp

    r6f39595 r9f473ba  
    3030{
    3131    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));
    3335    query.bindValue(":id", id);
    3436    query.bindValue(":conf", conferenceId);
     
    4042{
    4143    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));
    4347    query.bindValue(":conf", conferenceId);
    4448    query.bindValue(":start", convertToDb(date, QVariant::DateTime));
     
    5155{
    5256    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));
    5460    query.bindValue(":conf", conferenceId);
    5561    query.bindValue(":start", convertToDb(date, QVariant::DateTime));
Note: See TracChangeset for help on using the changeset viewer.