> <cfquery datasource="qwerty" name="asdfgh">
> select count(*)
> from customer
> where CustomerName='My_Name'
> </cfquery>
>
> <cfoutput query="asdfgh">
>
> #What I need to put here???#
>
> </cfoutput>
You'll need to alias your aggregate function:
SELECT COUNT(*) AS SomeVariableNameOfYourChoice ...
then reference that in your CFOUTPUT:
#myquery.SomeVariableNameOfYourChoice#
Also, I noticed in your signature that you're a:
> Certified Cold Fusion 4.1 Programmer.
I didn't even know there was a 4.1 version! Just kidding.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
