Pretty easy, and fun too, in MX.
cfcatch ...
cfmail to... from.. ect
cfdump var=#cfcatch#
/cfmail
/cfcatch
The same thing will work in other version, but I don't remember when cfdump
came along? 5? MX? If you don't have the dump, you'll just have to do a bit
more
Here's the basic idea. You can make it far more complex, but all mechanisms
basically boil down to this.
cftry
... potentially failing code
cfcatch type=any
cfmail to=[EMAIL PROTECTED]
from=[EMAIL PROTECTED]
Heylo
Im using a cftry - cfcatch sort of thing for the first
time, and I want to
email myself the error message that gets produced... How
do you do this?
TIA,
Ryan
simplest solution:
cftry
cfcatch
cfmail type=html ...
cfdump var=#cfcatch#
/cfmail
SELECT Functubakthing, Count(Functubakthing) AS Count
FROM Table
GROUP BY Functubakthing
hth
e
From: James Taavon [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: What should be easy has eluded me...
Date: Wed, 10 Jan 2001 16:06:53 -0500
I am trying to
yep, thanks.
"Christopher Olive, CIO" wrote:
recordcount is the number of records returned by the query. you're looking
for something like
select agency, count(*) as thecount
fromoimdbadm.assigned
where completed = 'Incomplete'
GROUP BY agency
recordcount is the number of records returned by the query. you're looking
for something like
select agency, count(*) as thecount
fromoimdbadm.assigned
where completed = 'Incomplete'
GROUP BY agency
ORDER BY agency
this will give you the number of
6 matches
Mail list logo
