From a477a1998c03bc0e7251463aff5486e3c0872d23 Mon Sep 17 00:00:00 2001 From: am Date: Fri, 17 Jul 2009 17:36:23 +0000 Subject: Huge changes: -Created an application icon and one for archives -implemented database configuration dialog -implemented listeditor -implemented covereditor -implemented md5sum helper -implemented archivefilewidget -Debugging spree: fixed SQL-statements and ListModel git-svn-id: file:///var/svn/repos2/shemov/trunk@389 f440f766-f032-0410-8965-dc7d17de2ca0 --- movieitem.cpp | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'movieitem.cpp') diff --git a/movieitem.cpp b/movieitem.cpp index b2fa545..9fb11e1 100644 --- a/movieitem.cpp +++ b/movieitem.cpp @@ -53,7 +53,8 @@ const QVariant MovieItem::dataAt(int column) const { } void MovieItem::populate(){ - QSqlQuery movieData("SELECT ttitle, tfilename, cmd5sum, bisize, igenreid, iquality, idvd FROM movies WHERE imovid = :id"); + QSqlQuery movieData; + movieData.prepare("SELECT ttitle, tfilename, cmd5sum, bisize, igenreid, iquality, idvd FROM movies WHERE imovid = :id"); movieData.bindValue(":id", mId); movieData.exec(); for(int i = 0; i < mNumRows; ++i){ @@ -65,7 +66,8 @@ void MovieItem::populate(){ void MovieItem::setGenreName(){ qint32 genreId = dataAt(Genre).toInt(); - QSqlQuery genreQuery("SELECT tgenrename FROM genre WHERE igenreid = :id"); + QSqlQuery genreQuery; + genreQuery.prepare("SELECT tgenrename FROM genre WHERE igenreid = :id"); genreQuery.bindValue(":id", genreId); genreQuery.exec(); while(genreQuery.next()){ @@ -74,7 +76,8 @@ void MovieItem::setGenreName(){ } void MovieItem::setActors(){ - QSqlQuery actorQuery("SELECT actor.tactorname FROM actors, actormoviemap WHERE actormoviemap.iactorid = actor.iactorid AND actormoviemap.imovid = :id"); + QSqlQuery actorQuery; + actorQuery.prepare("SELECT actor.tactorname FROM actor, movieactormap WHERE movieactormap.iactorid = actor.iactorid AND movieactormap.imovid = :id"); actorQuery.bindValue(":id", mId); actorQuery.exec(); while(actorQuery.next()){ -- cgit v1.2.3-70-g09d2