diff options
author | ivan <ivan> | 2010-02-13 02:17:06 +0000 |
---|---|---|
committer | ivan <ivan> | 2010-02-13 02:17:06 +0000 |
commit | a1ead42e90dd1f98a5cfd07fcbda7bdab23063f7 (patch) | |
tree | cc852b703d6e96e19fda82aa2e89c4baed42767f /httemplate/search/inventory_item.html | |
parent | 250b4e946383d7eea2a6ce3691879bcf0bab8326 (diff) |
fix inventory item search w/customer classes
Diffstat (limited to 'httemplate/search/inventory_item.html')
-rw-r--r-- | httemplate/search/inventory_item.html | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/search/inventory_item.html b/httemplate/search/inventory_item.html index 06b0847..3f0288b 100644 --- a/httemplate/search/inventory_item.html +++ b/httemplate/search/inventory_item.html @@ -79,7 +79,7 @@ die "access denied" my $classnum = $cgi->param('classnum'); $classnum =~ /^(\d+)$/ or errorpage("illegal classnum $classnum"); $classnum = $1; -my $extra_sql = 'inventory_item.classnum = $classnum '; +my $extra_sql = "WHERE inventory_item.classnum = $classnum "; my $inventory_class = qsearchs( { 'table' => 'inventory_class', @@ -98,7 +98,7 @@ if ( $cgi->param('avail') ) { } my $count_query = - "SELECT COUNT(*) FROM inventory_item WHERE $extra_sql"; + "SELECT COUNT(*) FROM inventory_item $extra_sql"; my $link = sub { my $inventory_item = shift; |