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
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">