From 62eecf24480520e204ab0057f8f7845c13f37c13 Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Sat, 19 Feb 2005 00:01:47 +0000
Subject: Bug 280494: Replace "SELECT LAST_INSERT_ID()" with Bugzilla::DB
 function call Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat,
 a=justdave

---
 editproducts.cgi | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)

(limited to 'editproducts.cgi')

diff --git a/editproducts.cgi b/editproducts.cgi
index f066f7029..11658c29a 100755
--- a/editproducts.cgi
+++ b/editproducts.cgi
@@ -506,8 +506,7 @@ if ($action eq 'new') {
             SqlQuote($votestoconfirm) . "," .
             SqlQuote($defaultmilestone) . "," .
             SqlQuote($classification_id) . ")");
-    SendSQL("SELECT LAST_INSERT_ID()");
-    my $product_id = FetchOneColumn();
+    my $product_id = $dbh->bz_last_key('products', 'id');
 
     SendSQL("INSERT INTO versions ( " .
           "value, product_id" .
@@ -531,8 +530,7 @@ if ($action eq 'new') {
                 "VALUES (" .
                 SqlQuote($productgroup) . ", " .
                 SqlQuote("Access to bugs in the $product product") . ", 1, NOW())");
-        SendSQL("SELECT last_insert_id()");
-        my $gid = FetchOneColumn();
+        my $gid = $dbh->bz_last_key('groups', 'id');
         my $admin = GroupNameToId('admin');
         # If we created a new group, give the "admin" group priviledges
         # initially.
-- 
cgit v1.2.3-24-g4f1b