Changeset c8b84e1
- Timestamp:
- 06/22/11 23:07:29 (12 years ago)
- Branches:
- master, qt5
- Children:
- 4b8ce66
- Parents:
- bad5e8a
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
BUGS
rbad5e8a rc8b84e1 5 5 BugId: 1 6 6 Title: Persons are not deleted when deleting a conference. 7 Status: Fixed. 7 8 ------------------------------------------------------------------- 8 9 BugId: 2 9 10 Title: SQL injections possible. 11 Status: 10 12 ------------------------------------------------------------------- -
src/sql/sqlengine.cpp
rbad5e8a rc8b84e1 349 349 execQueryWithParameter(db, "DELETE FROM EVENT_PERSON WHERE xid_conference = :xid_conference", params); 350 350 execQueryWithParameter(db, "DELETE FROM EVENT WHERE xid_conference = :xid_conference", params); 351 execQueryWithParameter(db, "DELETE FROM ROOM WHERE xid_conference = :xid_conference", params); 352 execQueryWithParameter(db, "DELETE FROM PERSON WHERE xid_conference = :xid_conference", params); 353 execQueryWithParameter(db, "DELETE FROM TRACK WHERE xid_conference = :xid_conference", params); 351 354 execQueryWithParameter(db, "DELETE FROM CONFERENCE WHERE id = :xid_conference", params); 352 execQuery(db, "DELETE FROM ROOM WHERE NOT EXISTS(SELECT * FROM EVENT_ROOM WHERE xid_room = ROOM.id)");353 execQuery(db, "DELETE FROM PERSON WHERE NOT EXISTS(SELECT * FROM EVENT_PERSON WHERE xid_person = PERSON.id)");354 355 355 356 commitTransaction();
Note: See TracChangeset
for help on using the changeset viewer.