Re: Help with database query


Come for the quick hacks, stay for the epiphanies.
	PerlMonks

Re: Help with database query

by NetWallah (Canon)

on Mar 15, 2013 at 02:37 UTC ( [id://1023601]=note: print w/replies, xml )

Need Help??

in reply to Help with database query

Untested Pseudocode.. (Assuming you use DBI )

  # Assumes DBI RaiseError is set ...
  my $sth = $dbh->prepare ("SELECT ID from $tbl where ID=?");

  for my $id (1..10_000){
      $sth->execute ($id);
      next if $sth->fetchrow_arrayref; 
      # This ID ($id)  was absent
      # Generate web page here...
  }
[download]

"I'm fairly sure if they took porn off the Internet, there'd only be one website left, and it'd be called 'Bring Back the Porn!'"
-- Dr. Cox, Scrubs