From 4ea362bfa2d2ea984996439e0c32cb4ea6dda7ee Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 25 Mar 2002 14:59:06 +0000 Subject: customers by otaker report (ugly search/cust_main.cgi mods; revert if they cause problems) --- httemplate/search/cust_main-otaker.cgi | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100755 httemplate/search/cust_main-otaker.cgi (limited to 'httemplate/search/cust_main-otaker.cgi') diff --git a/httemplate/search/cust_main-otaker.cgi b/httemplate/search/cust_main-otaker.cgi new file mode 100755 index 000000000..b7173c49c --- /dev/null +++ b/httemplate/search/cust_main-otaker.cgi @@ -0,0 +1,29 @@ + + + Customer Search + + + + Customer Search + +
+
+ Search for Order taker: + + <% my $dbh = dbh; + my $sth = dbh->prepare("SELECT DISTINCT otaker FROM cust_main") + or eidiot $dbh->errstr; + $sth->execute() or eidiot $sth->errstr; +# my @otakers = map { $_->[0] } @{$sth->selectall_arrayref}; + %> + +

+ +

+ + + -- cgit v1.2.1 From e0c62c388f74e543328f3691e8a8a1edb451a804 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 10 Jun 2004 11:28:19 +0000 Subject: tyop --- httemplate/search/cust_main-otaker.cgi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/search/cust_main-otaker.cgi') diff --git a/httemplate/search/cust_main-otaker.cgi b/httemplate/search/cust_main-otaker.cgi index b7173c49c..68569f085 100755 --- a/httemplate/search/cust_main-otaker.cgi +++ b/httemplate/search/cust_main-otaker.cgi @@ -11,7 +11,7 @@ Search for Order taker: <% my $dbh = dbh; - my $sth = dbh->prepare("SELECT DISTINCT otaker FROM cust_main") + my $sth = $dbh->prepare("SELECT DISTINCT otaker FROM cust_main") or eidiot $dbh->errstr; $sth->execute() or eidiot $sth->errstr; # my @otakers = map { $_->[0] } @{$sth->selectall_arrayref}; -- cgit v1.2.1 From 4dbd0e09bd8fe1958eb294ebd425878c420afe6a Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 18 Jun 2004 10:28:11 +0000 Subject: masonize fix: avoid newline prepend fix from borking indented first <%, fixes customer search by otaker under mason, closes: Bug#830 --- httemplate/search/cust_main-otaker.cgi | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) (limited to 'httemplate/search/cust_main-otaker.cgi') diff --git a/httemplate/search/cust_main-otaker.cgi b/httemplate/search/cust_main-otaker.cgi index 68569f085..44214368a 100755 --- a/httemplate/search/cust_main-otaker.cgi +++ b/httemplate/search/cust_main-otaker.cgi @@ -10,10 +10,9 @@
Search for Order taker: - <% my $dbh = dbh; - my $sth = $dbh->prepare("SELECT DISTINCT otaker FROM cust_main") - or eidiot $dbh->errstr; - $sth->execute() or eidiot $sth->errstr; + <% my $sth = dbh->prepare("SELECT DISTINCT otaker FROM cust_main") + or die dbh->errstr; + $sth->execute() or die $sth->errstr; # my @otakers = map { $_->[0] } @{$sth->selectall_arrayref}; %> <% my $sth = dbh->prepare("SELECT DISTINCT otaker FROM cust_main") -- cgit v1.2.1