Link to home
Start Free TrialLog in
Avatar of Panos
PanosFlag for Germany

asked on

Set the remaining time in -datediff in coldfusion

Hello experts
I have a users table with dateregister column (in datetime format).
A registered user has 24 hours to activate his account.
When he is trying to login without having activated his account i want to show him what time he has left to activate it or else his account will be deleted.
I have the query:
<cfquery name="CheckPersonAct" datasource="#request.dsn#">
        SELECT Password, email, user_ID ,Activation, user_uuid,dateregister
        FROM users
        WHERE email = <cfqueryparam value="#Form.lemail#" cfsqltype="CF_SQL_VARCHAR">
        AND Password = <cfqueryparam value="#VARIABLES.hashedPass#" cfsqltype="cf_sql_varchar">
        AND Activation = <cfqueryparam value="0" cfsqltype="cf_sql_numeric">
      </cfquery>
 
ASKER CERTIFIED SOLUTION
Avatar of azadisaryev
azadisaryev
Flag of Hong Kong image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Panos

ASKER

Thank you again azadi for your help
regards
panos