Re: Call History script

jmercer ( (no email) )
Fri, 05 Jun 1998 08:33:12 -0500

Now the error is No destination field name in INSERT INTO statement

What fields should be in the CallHistory Table I'm using the enhanced db
file from the ftp site but I'm not sure it has all the required fields.

*********** REPLY SEPARATOR ***********

On 6/4/98, at 11:39 PM, Dale E. Reed Jr. wrote:

>jmercer wrote:
>> Running a test in MSQuery it gives me the error Didn't expect
>> after the SELECT column list.
>Actually, I had the syntax backwards. Assuming you have a CallHistory
>table with the correct columns, this should do it:
>Insert Into CallHistory
>Select Username, CallDate='5/1/98', Mins=Sum(AcctSessionTime/60+1)
>From Calls
>Where CalLDate >= '5/1/98'
> and CallDate < '6/1/98'
> and AcctStatusType = 2
>Group By UserName
>Order By Username
>Dale E. Reed Jr. (
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |

Jerry Mercer
Internet -