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>
- QueryAddColumn() - add a column to a query with its value
- QueryAddRow() - add a specified number of empty rows to a query
- QuerySetCell() - set a cell to a value in a query object
- QuotedValueList() - get a delimited List from an executed query
- cfquery - select data
- cfdump - dump query
- cfquery - delete data
- cfquery - insert data
- cfquery - result attribute