--- Forwarded mail from [EMAIL PROTECTED]
Date: Mon, 12 Jun 2000 19:10:17 +1000 (EST)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: BOUNCE [EMAIL PROTECTED]: Non-member submission from
[[EMAIL PROTECTED]]
>From mikem Mon Jun 12 19:10:13 2000
Received: by oscar.open.com.au (8.9.0/8.9.0) id TAA21889
for [EMAIL PROTECTED]; Mon, 12 Jun 2000 19:10:12 +1000 (EST)
From: [EMAIL PROTECTED]
>Received: from zeus.vin.nl (zeus.vin.nl [212.206.24.246]) by
perki.connect.com.au with SMTP id SAA28930
(8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Mon, 12 Jun 2000 18:59:45 +1000
(EST)
Received: from zeus.vin.nl (zeus.vin.nl [212.206.24.246]) by
perki.connect.com.au with SMTP id SAA28930
(8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Mon, 12 Jun 2000 18:59:45 +1000
(EST)
Received: (qmail 32346 invoked by uid 0); 12 Jun 2000 08:59:34 -0000
Date: Mon, 12 Jun 2000 10:59:34 +0200
To: Robert Mann <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: Re: (RADIATOR) Duplicate accounting records - MySQL
Message-ID: <[EMAIL PROTECTED]>
References: <002701bfd358$3cf2ef80$[EMAIL PROTECTED]>
<0006111830344W.05261@hugo>
Mime-Version: 1.0
Content-Disposition: inline
User-Agent: Mutt/1.2i
In-Reply-To: <0006111830344W.05261@hugo>; from [EMAIL PROTECTED] on Sun, Jun 11,
2000 at 06:26:34PM +1000
Content-Type: text/plain; charset=us-ascii
Hi,
On Sun, Jun 11, 2000 at 06:26:34PM +1000, Hugh Irvine wrote:
> > What is the easiest way to address this problem with MySQL.
> I am working on a companies Radiator server that uses MySQL as its database
> server for accounting and there are many duplicate records. In MS SQL it was
> easy as I could use a constraint that would prevent it from happening but it
is
> my understanding that MySQL does not have this functionality. If I am wrong
> please right me and give me an example. If I am right then how do you work
> around this problem?
I had the same problem... and the easiest solution I could find is
making the reporting software (which I wrote in PHP) check for duplicates
when generating a report. It's easy to recognize the duplicated records.
Ricardo.
---End of forwarded mail from [EMAIL PROTECTED]
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
2000, NT, MacOS X
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
