cfquery - insert data
cfqueryInsert.cfm
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>cfquery tag example: how to insert data</title>
</head>
<body>
<h2 style="color:hotpink">cfquery example: data insert</h2>
<cfquery name="qAuthorsInsert" datasource="cfbookclub" result="AuthorsInsert">
INSERT INTO AUTHORS (FirstName, LastName) VALUES('Forta','Ben')
</cfquery>
<cfdump var="#AuthorsInsert#">
<cfquery name="qAuthors" datasource="cfbookclub">
SELECT AuthorID, LastName, FirstName FROM AUTHORS
</cfquery>
<cfdump var="#qAuthors#">
</body>
</html>