my $dbh = dbh;
my @where = ();
- my $orderby;
+ my $orderby = "ORDER BY cust_main.custnum";
# initialize these to prevent warnings
$params = {
}
}
- $orderby ||= "ORDER BY cust_main.$field";
+ $orderby .= ", cust_main.$field";
}
# setup queries, subs, etc. for the search
##
- $orderby ||= 'ORDER BY custnum';
+ $orderby ||= 'ORDER BY cust_main.custnum';
# here is the agent virtualization
push @where,