[946] in Moira
box_id in users
daemon@ATHENA.MIT.EDU (Chris Cook)
Fri Jan 5 07:42:34 1996
From: Chris Cook <scocc@thor.cf.ac.uk>
To: moira@MIT.EDU
Date: Fri, 5 Jan 1996 12:37:59 +0000 (GMT)
Can anyone tell me if there's any risk in creating a record in strings with
string_id = 0? Moira sets box_id in users to the string_id. This appears to
be set to zero if the user has never had a non-POP potype. My simplistic SQL
skills couldn't think of a better way of extracting
Username, box-type, POP machine, optional SMTP address
other than inserting a record in strings with string_id = 0, then
SELECT login, potype, name, string
from users, machine, strings
where (mach_id = pop_id)
and (box_id = string_id );
Thanks for any info,
Chris
_____________________________________________________________________________
| Chris Cook - Postmaster, UNIX and Athena Administrator |
| University of Wales E-mail : CookC@Cardiff.AC.UK |
| College of Cardiff, Phone : +44 1222 874875 |
| 40-41 Park Place, (Direct) : +44 1222 874219 |
| Cardiff, UK Fax : +44 1222 874285 |
|___________________________________________________________________________|
