[1736] in Moira
Re: reformat spwatch dcm file
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Thu Jan 18 12:26:16 2001
Message-Id: <200101181726.MAA01037@riff-raff.mit.edu>
To: Jonathon Weiss <jweiss@MIT.EDU>
cc: moiradev@MIT.EDU
In-Reply-To: Your message of "Thu, 18 Jan 2001 06:10:01 EST."
<200101181110.GAA12191@Bearing-An-Hourglass.mit.edu>
Date: Thu, 18 Jan 2001 12:26:11 -0500
From: Garry Zacheiss <zacheiss@MIT.EDU>
>> ! $sth = $dbh->prepare("SELECT m.name FROM printers p, ".
>> "machine m WHERE p.type = 'SAP' AND p.mach_id = ".
>> "m.mach_id ORDER BY p.name") || exit $MR_DBMS_ERR;
If we're no longer including the printer's name in the datafile,
we shouldn't order by it; I would change the ORDER BY clause to be by
m.name.
It's fine other than that.
Garry
