Secondly will the timeon3.cfm work with CF3.0 or just 4.0?
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...
TIA
Jason Roblyer
NCTC
jason@nctc.net
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart