-- "NIPP, SCOTT V \\(SBCSI\\)" <[EMAIL PROTECTED]>
OK... I have been able to solve this problem, and it was no big
deal. However, the problem I am currently facing is really hosing me
up... Basically, a "NULL" field is getting converted to a 0 in the
database. This causes a comparison
On Tue, 2005-03-15 at 13:24 -0600, NIPP, SCOTT V (SBCSI) wrote:
> $dbh->do(qq{
> INSERT INTO AllMid_Hist VALUES (?".(",?" x 22)."))}, #
> This is where I run into issues.
> undef,@old,NOW()); # I am not sure how to
> structure this syntax and not hav
.com
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 1:34 PM
To: NIPP, SCOTT V (SBCSI); dbi-users@perl.org
Subject: RE: Insert help...
Doesn't MySQL have the concept of a unique or primary key constraint?
If it does, why not ...
1. IN
Doesn't MySQL have the concept of a unique or primary key constraint? If it
does, why not ...
1. INSERT
2. If insert fails due to PK violation, perform archiving and update the row
This saves the cost of an extra insert (which is what the PK check sort of
performs ;)
I also would like to su
