The abve executes w/out error here (not returning any rows, though).
If you use iswl_w to execute it against your database, what
error is returned?
> Looking forward to hearing from you. By the way, while I was capturing the
> above SQL statement, I noticed a SQL statement updating the RadLogs table
> which as far as I can remember from the documentation was a debugging table
> used to logged different responses from the RadiusNT Service. When a quick
> select statement was executed on the RadLogs table, it was empty. What
> happened to the record(s) which as far as the SQL Trace showed were supposed
> to have updated the table??? Help....
You may not have the data field in your RadLogs table (and the insert
is failing). If you don't, then run the following tidbit in isql_w:
ALTER TABLE RadLogs
ADD Data varchar (50) NULL DEFAULT NULL
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com