Thank you that did exactly what I was looking for.
Support Open Instant Messaging Protocols
> -----Original Message-----
> From: Ryan Fox [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 29, 2002 16:08
> To: Jefferson Cowart
> Cc: [EMAIL PROTECTED]
> Subject: Re: Time Allocation Issue
> > I have tried doing just a unique
> > index on referee, date, and time but the issue is I use a 0
> to indicate
> > that the slot is open.
> > there any better more efficient way to do this?
> Use null to indicate the slot is open. Your unique index can have
> multiple null values, but not multiple zero values. I believe this is
> what you are looking for.
> Ryan Fox
> [EMAIL PROTECTED]
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php