you need to alias the field.
<cfquery datasource="qwerty" name="asdfgh">
select count(*) as fred
from customer
where CustomerName='My_Name'
</cfquery>
<cfoutput query="asdfgh">
#fred#
</cfoutput>
-----Original Message-----
From: Alex Puriche [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 11:54 AM
To: [EMAIL PROTECTED]
Subject: SQL.COUNT question
cf-talk,
<cfquery datasource="qwerty" name="asdfgh">
select count(*)
from customer
where CustomerName='My_Name'
</cfquery>
<cfoutput query="asdfgh">
#What I need to put here???#
</cfoutput>
--
Regards,
Alex mailto:[EMAIL PROTECTED]
Certified HTML Programmer,
Java Script Programmer and
High IT Aptitude Specialist.
http://www.brainbench.com/transcript.jsp?pid=145368
Certified Cold Fusion 4.1 Programmer.
http://www.ecertifications.com/
Permanent FAQ Team player.
http://faq.worldrecovery.com/
Permanent MTeam player.
http://members.tripod.com/mteam1/
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
