Re: [Emerald] SQL - timeon2.cfm scripts

sikko@igr.nl
Wed, 7 Jul 1999 08:42:09 +0200

From: "Jason" <jason@nctc.net>
To: <emerald@iea-software.com>
Subject: Re: [Emerald] SQL - timeon2.cfm scripts
Date sent: Tue, 6 Jul 1999 16:05:37 -0500
Send reply to: emerald@iea-software.com

> 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 would be interested in these CFM files also, Can I FTP them
somewhere?
>
> 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

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
S.K. de Graaf
IGR INTERNET your partner in Cyberspace
tel 010-5010505
fax 010-5014748

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart