From: Steinar H. Gunderson <sesse@debian.org>
Date: Mon, 26 Mar 2007 20:33:08 +0000 (+0200)
Subject: Trim the EXIF values; seems like the Pentax K10D sometimes adds extra spaces
X-Git-Url: https://git.sesse.net/?p=pr0n;a=commitdiff_plain;h=6b6a6afa90a6be24ae430324ec5ca7fd83f4fe93

Trim the EXIF values; seems like the Pentax K10D sometimes adds extra spaces
after its model.
---

diff --git a/perl/Sesse/pr0n/Index.pm b/perl/Sesse/pr0n/Index.pm
index 737eba6..5a635d4 100644
--- a/perl/Sesse/pr0n/Index.pm
+++ b/perl/Sesse/pr0n/Index.pm
@@ -156,8 +156,8 @@ sub handler {
 		# Find the equipment used
 		my $eq = $dbh->prepare('
 			SELECT 
-				model.value AS model,
-				coalesce(lens_spec.value, lens.value) AS lens,
+				TRIM(model.value) AS model,
+				coalesce(TRIM(lens_spec.value), TRIM(lens.value)) AS lens,
 				COUNT(*) AS num
 			FROM images i
 				LEFT JOIN exif_info model ON i.id=model.image