<cfoutput> a MySQL和函数

Question

我理解SQL和函数。这是我的代码：

<cfquery name="sum" datasource="expense_db" username = "for" password = "bar">
  SELECT sum(amount) 
  FROM expense
</cfquery> 

如何输出查询的结果？我只想输出“金额”列的和

Answer 1

您可以为该列使用别名，并在Cold聚变代码中使用该列名。

https://www.w3schools.com/sql/sql_alias.asp

<cfquery name="sum" datasource="expense_db" username = "for" password = "bar">
  SELECT sum(amount) AS Total 
  FROM expense
</cfquery> 

<cfoutput>#sum.Total#</cfoutput><!--- query_name.column_name --->