3 <TITLE>Customer Search</TITLE>
5 <BODY BGCOLOR="#e8e8e8">
10 <FORM ACTION="cust_main.cgi" METHOD="post">
11 Search for <B>Order taker</B>:
12 <INPUT TYPE="hidden" NAME="otaker_on" VALUE="TRUE">
13 <% my $sth = dbh->prepare("SELECT DISTINCT otaker FROM cust_main")
15 $sth->execute() or die $sth->errstr;
16 # my @otakers = map { $_->[0] } @{$sth->selectall_arrayref};
18 <SELECT NAME="otaker">
19 <% my $otaker; while ( $otaker = $sth->fetchrow_arrayref ) { %>
20 <OPTION><%= $otaker->[0] %></OTAKER>
23 <P><INPUT TYPE="submit" VALUE="Search">