From a51a2c621121da3e2866ba047ca314f20dcce28c Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Sat, 13 Dec 2014 19:18:18 +0100 Subject: [PATCH] limit to just my boiler model --- db3-dump.pl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/db3-dump.pl b/db3-dump.pl index fdaa541..953645c 100755 --- a/db3-dump.pl +++ b/db3-dump.pl @@ -46,8 +46,9 @@ select Id, TexteEN from "UnitNames" my $diags = lookup( qq{ select Id,x0136,x0142,x0144,x0147,x0151,x0152,x0153,x0158,x0160,x0161 from "DiagnoseDaten" +where x0147 = 1 }); -warn "# diags = ",dump($diags); +#warn "# diags = ",dump($diags); my $sth = $dbh->prepare( qq{ select * from "ComuInfos" -- 2.20.1