I have the query which work just fine. Now i was told to add 1 more column into the table to record first time login. So if the first time login is blank then put current date, if not empty then do nothing . How can i achive this
<cfquery name="putLoggedIn" datasource="cfelsunrise" dbtype="ODBC"> <!--- Update Employee's records ---> update Employee set LastLoginDate = GetDate(), FirstLOginDate=<cfif FirstLoginDate eq ''>=GetDate()</cfif> where EmployeeID = #session.EmpID# </cfquery>