Dear All: I was trying to insert some numbers into an Access table. There were already some numbers in this table. I did not want to insert those numbers that already in the table. So I first read the number into an array named @IDnumber. Then I use the following code,

............
    $ua=new LWP::UserAgent;
      $ua->timeout ([180]);
      $request = new HTTP::Request('GET', $url);
      $response=$ua->request($request);
      if (!($response->is_success)) {
          print " Error can not load! \n  ";
      }

.........

NEXTLINE1:     while ($CONTENDS=~ /\d{10}/g) {
        $match=$&;
        $CONTENDS=$';        
        $count=0;
        while ($count<=@IDnumber) {
        if ($match == $IDnumber[$count]){
        goto NEXTLINE1;
          }
    $count++;
              }    
        push  (@IDnumber1, $match);           
            }
............
   for ($Inde=0;$Inde<=@IDnumber1;$Inde++){
   my $match=$IDnumber1[$Inde];
  $sqlinsert="INSERT INTO $tab[$loop] VALUES('$match')";
                 $rc=$db->Sql($sqlinsert);
                die qq(SQL fail "$rc":), $db->Error(),qq(n) if $rc;  
   }
[download]

But I did not succeed. Duplicated numbers were inserted into the table. Could anybody help me to figure out whats wrong with my code? Thank you very much in advance. .... Luoina

---

---

• Are you posting in the right place? Check out Where do I post X? to know for sure.
• Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:

  <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>

• Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
• Want more info? How to link or How to display code and escape characters are good places to start.