Alias the sum and then output that alias.
SELECT SUM(racedaylunch) as mySum
<cfoutput>#exlunch.mySum#</cfoutput>
-David
On Monday, June 25, 2001 9:09 AM, Jeff Fongemie [SMTP:[EMAIL PROTECTED]] wrote:
> Hello cf-talk,
>
> Why the heck is this throwing an error? "Expression result cannot be
> converted to a string"
>
> <cfquery name="exlunch" datasource="#application.dsn#" dbtype="ODBC">
> SELECT SUM(racedaylunch)
> FROM thelist
> </cfquery>
>
>
> <cfoutput>#exlunch#</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
