query on "process_cgi"

ukhas jean ukh_dtl at yahoo.com
Wed Oct 4 07:31:38 UTC 2006

  Thats sounds cool ... hmm ... but how is the script keeping track of the records it is deleting??

David Miller <justdave at bugzilla.org> wrote:
  ukhas jean wrote on 10/4/06 1:21 AM:
> Hello Dave et al,
> Thanks ... i think i understand the logic behind it now ... one more
> question ... 
> Y is this SQL query required ?? i cant figure y deletion of keywords
> have to take place ... ??
> Following is snippet of code from process_bug.cgi:-
> my $changed = 0;
> if ($keywordaction eq "makeexact") {
> SendSQL("DELETE FROM keywords WHERE bug_id = $id");
> $changed = 1;
> }

Because if you're making it exactly that list, then none of the existing
keywords need to be on that bug (well, maybe some of them might, but
it's easier to delete and re-add than to figure out which ones). So it
deletes the entire existing list before adding the new ones.

Dave Miller http://www.justdave.net/
System Administrator, Mozilla Corporation http://www.mozilla.com/
Project Leader, Bugzilla Bug Tracking System http://www.bugzilla.org/
To view or change your list settings, click here:

Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.  Great rates starting at 1¢/min.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bugzilla.org/pipermail/developers/attachments/20061004/8e75d965/attachment.html>

More information about the developers mailing list