From 1eee369e271161e2f7909ce87bfa4c297923d125 Mon Sep 17 00:00:00 2001 From: "bbaetz%student.usyd.edu.au" <> Date: Wed, 28 Aug 2002 11:27:21 +0000 Subject: Bug 165080 - Delete product fails with missing column error r=joel x2 --- editproducts.cgi | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'editproducts.cgi') diff --git a/editproducts.cgi b/editproducts.cgi index 520e46d50..5b4c3c249 100755 --- a/editproducts.cgi +++ b/editproducts.cgi @@ -416,7 +416,7 @@ if ($action eq 'del') { CheckProduct($product); # display some data about the product - SendSQL("SELECT product_id, description, milestoneurl, disallownew + SendSQL("SELECT id, description, milestoneurl, disallownew FROM products WHERE name=" . SqlQuote($product)); my ($product_id, $description, $milestoneurl, $disallownew) = FetchSQLData(); @@ -634,7 +634,7 @@ if ($action eq 'delete') { print "Milestones deleted.
\n"; SendSQL("DELETE FROM products - WHERE product_id=$product_id"); + WHERE id=$product_id"); print "Product '$product' deleted.
\n"; # Added -JMR, 2/16/00 -- cgit v1.2.3-24-g4f1b