Changeset bcf67d6 for src/sql/sqlengine.cpp
- Timestamp:
- 01/28/10 22:55:25 (13 years ago)
- Branches:
- master, qt5
- Children:
- 8b0bf22
- Parents:
- 83020cd
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
src/sql/sqlengine.cpp
r83020cd rbcf67d6 320 320 execQuery( db, "CREATE TEMP TABLE SEARCH_EVENT ( xid_conference INTEGER NOT NULL, id INTEGER NOT NULL );"); 321 321 // INSERT 322 QString query = QString("INSERT INTO SEARCH_EVENT ( xid_conference, id ) "322 QString query = QString("INSERT INTO SEARCH_EVENT ( xid_conference, id ) " 323 323 "SELECT EVENT.xid_conference, EVENT.id FROM EVENT "); 324 324 if( aColumns.contains("ROOM") ){ 325 query += "INNER JOIN EVENT_ROOM ON ( EVENT.xid_conference = EVENT_ROOM.xid_conference AND EVENT.id = EVENT_ROOM.xid_event ) ";325 query += "INNER JOIN EVENT_ROOM ON ( EVENT.xid_conference = EVENT_ROOM.xid_conference AND EVENT.id = EVENT_ROOM.xid_event ) "; 326 326 query += "INNER JOIN ROOM ON ( EVENT_ROOM.xid_room = ROOM.id ) "; 327 327 } 328 328 if( aColumns.contains("PERSON") ){ 329 query += "INNER JOIN EVENT_PERSON ON ( EVENT.xid_conference = EVENT_PERSON.xid_conference AND EVENT.id = EVENT_PERSON.xid_event ) ";329 query += "INNER JOIN EVENT_PERSON ON ( EVENT.xid_conference = EVENT_PERSON.xid_conference AND EVENT.id = EVENT_PERSON.xid_event ) "; 330 330 query += "INNER JOIN PERSON ON ( EVENT_PERSON.xid_person = PERSON.id ) "; 331 331 } … … 348 348 bool SqlEngine::execQuery(QSqlDatabase &aDatabase, const QString &aQuery) 349 349 { 350 qDebug() << "\nSQL: " << aQuery;350 //qDebug() << "\nSQL: " << aQuery; 351 351 352 352 QSqlQuery sqlQuery(aDatabase); … … 356 356 } 357 357 else{ 358 qDebug() << "SQL OK.\n";358 //qDebug() << "SQL OK.\n"; 359 359 return true; 360 360 }
Note: See TracChangeset
for help on using the changeset viewer.