I'm not sure. I only have CF4 here.
> I only ask because I immediatly installed it and when I go to logon I get
> the Invalid Username or Password message. I do have a DSN pointing to my
> Emerald DB in SQL and have verified it with CFAdmin ok. I turned on the
> debugging in CFAdmin and here is the pertinent info I get back:
>
> Queries
> USER (Records=0, Time=0ms)
> SQL =
> SELECT Login, AccountID
> FROM SubAccounts
> WHERE (Login = 'user' or EMail = 'user')
> AND Password = 'password'
> ----------------------------------------------------------------------------
> ----
> Execution Time
> 15 milliseconds
> ----------------------------------------------------------------------------
> ----
> Parameters
> Form Fields:
> USERNAME=user
> FIELDNAMES=USERNAME,PASSWORD
> PASSWORD=password
>
> It's the 15 millisecond execute time that is throwing me off. We have 1000
> users in the db shouldn't it take just a tad bit longer to check that.
> Anyway I get the same message no matter what username/password combo I use.
> I'm downloading CF40 from Allaire to see if it will work there...
That looks right. I wouldn't expect it to take that much time to lookup
a
username/password. RadiusNT can return a full RADIUS packet request in
30ms+,
doing a more complicated query.
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart