troubleshooting Question

modify cfdquery

Avatar of erikTsomik
erikTsomikFlag for United States of America asked on
DatabasesWeb ServersSQL
2 Comments1 Solution136 ViewsLast Modified:
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>
ASKER CERTIFIED SOLUTION
JesterToo

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros