shtakai
1/6/2017 - 6:38 AM

Example template of CFML(insertion and selection)

Example template of CFML(insertion and selection)

index2.cfm
content_copyfile_download
<cfquery datasource = "sashimi">
	insert into new_table (content) values ("日本語データ #now()#")
</cfquery>

<cfquery name = "qData" datasource = "sashimi" >
	SELECT * FROM new_table
</cfquery>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Document</title>
</head>
<body>
	<cfoutput>
		#qData.recordCount#
	</cfoutput>
	<ul>
	<cfoutput query="qData">
		<li>データ: #qData.id# : #qData.content#</li>
	</cfoutput>
	</ul>
</body>
</html>