> How can you
>
> if(update row fails because doesn't exist, ie. returns 0)then(insert row)
Depends on what interface you are using.
In perl DBI, the return value of the a $dbh->do("update...") should be
the nomber of rows inserted. Same with doing a sequence of
$sth=$dbh->prepare("update
I'm pretty sure someone already answered this, but the mail archive isn't
very searchable at the moment. How can you
if(update row fails because doesn't exist, ie. returns 0)then(insert row)
in SQL? Or am I misremembering and it was in some other language?
Cheers,
Patrick
