Try this,
<cfquery datasource="qwerty" name="asdfgh">
select count(*) as myvar
from customer
where CustomerName='My_Name'
</cfquery>
<cfoutput query="asdfgh">
#myvar#
</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.
