>Seldom wrong and right again, Shawn! Yes, I forgot to cover the
>reflexive case. I don't have a magic bullet for that scenario;
>you'd just have to check that with application code.
>
>But on re-reading his original post, it occurred to me that I
>had misread it completely. I just sent a note o
In article <[EMAIL PROTECTED]>,
"Scott Fletcher" <[EMAIL PROTECTED]> writes:
> Sorry you didn't understand what's I'm asking for. It take some logical
> thought to see the picture. Now I know I will have to enforce it with
> the application code (PHP, HTML and JavaScript) with the current two
>
t: Wednesday, October 20, 2004 4:59 PM
Subject: RE: How to make 1 primary key work for 2 columns
> But rhino, your constraints don't cover the case of :
>
> Primary Secondary
> ---
> [EMAIL PROTECTED] [EMAIL PROTECTED]
> [EMAIL
From: Rhino [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 20, 2004 3:30 PM
> To: Scott Fletcher
> Subject: Re: How to make 1 primary key work for 2 columns
>
>
> - Original Message -
> From: "Scott Fletcher" <[EMAIL PROTECTED]>
> To: <[E
that with with DB2 but MySQL is different.
Thanks,
Scott
- Original Message -
From: "Scott Fletcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 20, 2004 3:54 PM
Subject: How to make 1 primary key work for 2 columns
Hi! I'm tryin
a
Scott
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 3:28 PM
To: Scott Fletcher
Cc: [EMAIL PROTECTED]
Subject: Re: How to make 1 primary key work for 2 columns
I couldn't understand exactly what you were asking for. Did you want n
ddress, if not matched then it's okay to enter it
into the database. It's the only way...
Thanks,
Scott
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 3:30 PM
To: Scott Fletcher
Subject: Re: How to make 1 primary key work for 2 columns?
I couldn't understand exactly what you were asking for. Did you want no
duplicates between columns or no duplicates between companies or what?
This is something you will either enforce in your application code (with
your two column model) - OR - you will have to redesign your Primary and
Second
Hi! I'm trying to figure out how to make this possible... What I have
here is a company address, along with both the primary contact and
secondary contact. In them is one email address from the primary
contact and one other email address from the secondary contact. Problem
is setting an unique