How do I know if a record exsist?

Hi, I'm using Perl to maintain a database. I'd like to search for a record in a database and if it does not exist, add it. Otherwise, just update the fields. In my script, I have: $sqlCmd = $dbh-prepare("SELECT PortName FROM Ports where PortName = '$port' "); $sqlCmd-execute(); Where

Re: How do I know if a record exsist?

Don wrote: Hi, I'm using Perl to maintain a database. I'd like to search for a record in a database and if it does not exist, add it. Otherwise, just update the fields. In my script, I have: $sqlCmd = $dbh-prepare("SELECT PortName FROM Ports where PortName = '$port' ");