<div>
I would appreciate it if you would explain why you decided this answer merited a grade of &quot;B&quot;.
</div>


I would appreciate it if you would explain why you decided this answer merited a grade of "B".

<div>
<div class="content wysiwyg-content">
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 <br />
<br />

<pre><code id="code-70579">&lt;cfquery name=&quot;putLoggedIn&quot; datasource=&quot;cfelsunrise&quot; dbtype=&quot;ODBC&quot;&gt;		&lt;!--- Update Employee's records ---&gt;
		update Employee
			set LastLoginDate = GetDate(),
             FirstLOginDate=&lt;cfif FirstLoginDate eq ''&gt;=GetDate()&lt;/cfif&gt;
		where EmployeeID = #session.EmpID#
	&lt;/cfquery&gt;
</code></pre>
</div>
</div>


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 


modify cfdquery

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.

Web Servers

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.