Re: [Emerald] SQL - timeon2.cfm scripts

Dale E. Reed Jr. ( (no email) )
Tue, 06 Jul 1999 14:13:49 -0700

Jason wrote:
> First off...kudos and many thanks go to Dale, the hardest working guy I
> know.
> Secondly will the timeon3.cfm work with CF3.0 or just 4.0?

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:
> 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
username/password. RadiusNT can return a full RADIUS packet request in
doing a more complicated query.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: