- #if ( driver_name eq 'mysql' ) { #remove ORDER BY for mysql? hua?
- # @cust_pkg = qsearch('cust_pkg',{}, '', "$unconf $limit" );
- #} else {
- # @cust_pkg = qsearch('cust_pkg',{}, '', "$unconf ORDER BY pkgnum $limit" );
- #}
- @cust_pkg = qsearch('cust_pkg',{}, '', "$unconf ORDER BY pkgnum $limit" );
+ my $tblname = driver_name eq 'mysql' ? 'cust_pkg.' : '';
+ @cust_pkg =
+ qsearch('cust_pkg',{}, '', "$unconf ORDER BY ${tblname}pkgnum $limit" );