From 6786163a0c81b71435cf6070db90e0c4d4b59757 Mon Sep 17 00:00:00 2001 From: Arno Date: Mon, 19 Dec 2016 02:07:54 +0100 Subject: Replace RE match in OriginDialog with LIKE Unfortunately there is no Postgres equivalent for \Q \E, so the query didn't work with filenames containing e.g. () or []. Use LIKE instead and see when that comes back to haunt me :) --- origindialog.cpp | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'origindialog.cpp') diff --git a/origindialog.cpp b/origindialog.cpp index 3e8bd3a..f885132 100644 --- a/origindialog.cpp +++ b/origindialog.cpp @@ -107,8 +107,10 @@ void OriginDialog::setDstData(const QString &absolutefn){ QFileInfo fi(absolutefn); QSqlDatabase db = QSqlDatabase::database("shemovdb"); QSqlQuery dstQ(db); - dstQ.prepare("SELECT tfilename, iduration, bisize, cmd5sum, ifiles_id FROM files WHERE tfilename ~ :fnb"); - dstQ.bindValue(":fnb", fi.completeBaseName()); + dstQ.prepare("SELECT tfilename, iduration, bisize, cmd5sum, ifiles_id FROM files WHERE tfilename LIKE :fnb"); + QString fn = fi.completeBaseName(); + fn.append('%'); + dstQ.bindValue(":fnb", fn); dstQ.exec(); while(dstQ.next()){ mDstName->setText(dstQ.value(0).toString()); -- cgit v1.2.3-70-g09d2