How to create an empty query in ColdFusion

QueryNew() - create an empty query

QueryNew.cfm


<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>QueryNew function example: how to create an empty query (query object)</title>
</head>

<body>
<h2 style="color:HotPink">QueryNew Function Example</h2>

<cfset qEmployee=QueryNew("EmployeeID, FirstName, LastName","Integer, VarChar, VarChar")>

<cfset Temp=QueryAddRow(qEmployee,1)>

<cfset Temp=QuerySetCell(qEmployee,"EmployeeID",1,1)>
<cfset Temp=QuerySetCell(qEmployee,"FirstName","Jenny",1)>
<cfset Temp=QuerySetCell(qEmployee,"LastName","Jones",1)>

<cfdump var="#qEmployee#" label="empty query">

</body>
</html>





More ColdFusion examples