[Emerald Digest]

emerald-digest-request@iea-software.com
Wed, 27 May 1998 00:00:32 -0700

Message 1: Re: SQL Commands
from Michael Whisenant <mwhisen@airnet.net>

Message 2:
from "Blade" <blade@compuzone.net>

Message 3: RE:
from David Kerr <dkerr@phonet.com>

Message 4: Re: SQL Commands
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 5: RE: Serious Problem
from "Robert H. Clugston" <robert@csnsys.com>

Message 6: New Customer Info Sheet
from Carl Jagerski <carll@forcomm.net>

Message 7: Re: New Customer Info Sheet
from "Pat Augustine" <ereth@ilnk.com>

Message 8: Re: New Customer Info Sheet
from John Lange <radadmin@palacenet.net>

Message 9: Re: New Customer Info Sheet
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 10: RE: New Customer Info Sheet
from ronnie@itexas.net (Ronnie D. Franklin)

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: SQL Commands
From: Michael Whisenant <mwhisen@airnet.net>
Date: Tue, 26 May 1998 10:02:15 -0500

Dale,

Get some rest! We need you rested a tad, and working on Emerald 2.5. But
I tried this script and got another error message.

Msg 144, Level 15, State 1
Cannot use an aggregate or a subquery in an expression used for the by-list
of a GROUP BY clause.

At 04:42 PM 5/25/98 -0700, you wrote:
>Michael A. Davis Jr. wrote:
>>
>> Dale, I pasted your script in and ran it, but I got the following errors
>> back...
>
>Sorry. I must have been working to hard. :(
>
>Select DatePart(Year, CallDate), DatePart(Month, CallDate), Count(CallDate)
>From Calls
>Group By DatePart(Year, CallDate), DatePart(Month, CallDate), Count(CallDate)
>Order By DatePart(Year, CallDate), DatePart(Month, CallDate), Count(CallDate)
>
>--
>Dale E. Reed Jr. (daler@iea-software.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
Michael J. Whisenant
Vice-President, Operations
AIRnet Internet Services, Inc.
ph: (256) 704-4692 fax: (256) 704-2329

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject:
From: "Blade" <blade@compuzone.net>
Date: Tue, 26 May 1998 11:35:49 -0400

This is a multi-part message in MIME format.

------=_NextPart_000_000C_01BD889A.6EAFD480
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am running Emerald 2.1 w/ SQL Server 6.5. I currently have two users =
showing up in my calls on-line dialog, even though my NAS has been =
restarted... RadiusNT (2.2) won't let these two locked in people connect =
now. I have concurrency control enforced. Does anyone know a way to =
clear the calls online table so these people can log in? Thanx in =
advance.
=20
CompuZone NET Administrator
blade@compuzone.net
=20

------=_NextPart_000_000C_01BD889A.6EAFD480
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

I am running Emerald 2.1 w/ SQL =Server 6.5. I=20currently have two users showing up in my calls on-line dialog, even =though my=20NAS has been restarted... RadiusNT (2.2) won't let these two locked in =people=20connect now. I have concurrency control enforced. Does anyone know a way =to=20clear the calls online table so these people can log in? Thanx in=20advance.
 
CompuZone NET Administrator
blade@compuzone.net
 
------=_NextPart_000_000C_01BD889A.6EAFD480--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE:From: David Kerr Date: Tue, 26 May 1998 10:40:09 -0500