ount(email) as ecount
from users
group by email having (count(email) > 1)
John
[EMAIL PROTECTED]
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen
Sent: Thursday, January 24, 2008 9:53 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discus
rge Orwell, 1945
On Jan 24, 2008, at 7:45 AM, Dusty Hale wrote:
That was an excellent thought. I've never used cffinally but just
looked up what it does.
thx
-Dusty
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H.
Saxe
Sent: 01/24/2008 6:56 AM
To: discuss
gt; That was an excellent thought. I've never used cffinally but just looked
> up what it does.
>
> thx
>
> -Dusty
>
> --
> *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] <[EMAIL PROTECTED]>] *On
> Behalf Of *Dean H. Saxe
>
CTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H.
Saxe
Sent: 01/24/2008 6:56 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] closing database connections
Actually, you should wrap your code in a try/catch/finally block.
The closing of the connection should always happen in the finally
That was an excellent thought. I've never used cffinally but just looked up
what it does.
thx
-Dusty
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe
Sent: 01/24/2008 6:56 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] closing dat
Actually, you should wrap your code in a try/catch/finally block. The
closing of the connection should always happen in the finally block to
ensure that it closes if an exeption occurs.
That being said, once this object is out of scope, garbage collection
should close the connection for yo
Many thanks Darin. I added it to my cfc and the spikes in memory seem to be
under control now.
-Dusty
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darin Kohles
Sent: 01/23/2008 11:51 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] closing database
Looking back at some of my old Java code, you can (should?) close both your
query (aka statement) and your connection; so in your code just add the
lines:
st.close();
con.close();
Put that somewhere at then end, in that order, after you've got your return
data set. Close the Statement (and/or Pre
