From 61ddf0a32846fdf2607043d94af1a0a86b80f6fc Mon Sep 17 00:00:00 2001
From: "bbaetz%student.usyd.edu.au" <>
Date: Mon, 12 Aug 2002 12:42:42 +0000
Subject: Bug 43600 - Convert products/components to use ids instead of names.
 Initial attempt by jake@bugzilla.org, updated by me r=joel, preed

---
 importxml.pl | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

(limited to 'importxml.pl')

diff --git a/importxml.pl b/importxml.pl
index 964d29a6f..cffeca68c 100755
--- a/importxml.pl
+++ b/importxml.pl
@@ -570,9 +570,10 @@ for (my $k=1 ; $k <= $bugqty ; $k++) {
       push (@values, SqlQuote($qa_contact));
       push (@query, "qa_contact");
     } else {
-      SendSQL("select initialqacontact from components where program=" .
-              SqlQuote($product[0]) .
-              " and value=" . SqlQuote($component[0]) );
+      SendSQL("SELECT initialqacontact FROM components, products "
+              "WHERE components.product_id = products.id" .
+              " AND products.name = " . SqlQuote($product[0]) .
+              " AND components.name = " . SqlQuote($component[0]) );
       $qa_contact = FetchOneColumn();
       push (@values, SqlQuote(DBname_to_id($qa_contact)) );
       push (@query, "qa_contact");
-- 
cgit v1.2.3-24-g4f1b