Dave,
My _Thanks_ to all experienced people for help!
In fact, real query is a little bit intricate. :)))
Dave Also, I noticed in your signature that you're a:
Certified Cold Fusion 4.1 Programmer.
Dave I didn't even know there was a 4.1 version! Just kidding.
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
erm? to achieve what?
- Original Message -
From: Alex Puriche [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 19, 2000 4:54 PM
Subject: SQL.COUNT question
cf-talk,
cfquery datasource="qwerty" name="asdfgh"
select count(*)
from customer
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
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
-Original Message-
From: Alex Puriche [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 8:54 AM
To: [EMAIL PROTECTED]
Subject: SQL.COUNT question
cf-talk,
cfquery datasource="qwerty" name="asdfgh"
select count(*)
from customer
where CustomerName=
You need to use an alias:
select count(*) as numCusts
and then output #numCusts#
-cf-talk
On Wed, 19 Apr 2000 Alex Puriche [EMAIL PROTECTED] writes:
cf-talk,
cfquery datasource="qwerty" name="asdfgh"
select count(*)
from customer
where CustomerName='My_Name'
/cfquery
I think "fred" is a reserved word.
On Wed, 19 Apr 2000 [EMAIL PROTECTED] writes:
select count(*) as fred
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your
8 matches
Mail list logo