At my wits end. Im trying to find duplicate users in a database...
The closest I can find to in the Forta book is:
<CFQUERY DATASOURCE="userdb">
SELECT SUM(username) FROM users GROUP BY username
</CFQUERY>
But I tried that last week and it doesnt work.
I'd like it just to do
<cfif num_user_records GT 1>
#username#<br>
</cfif>
Should I use a cfloop, list, array?
-----Original Message-----
From: Chris Farrugia <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Monday, March 27, 2000 7:17 PM
Subject: Seeing this?
I can't seem to get my messages to post on the list. Lets see if this one
works.
----------------------------------------------------------------------------
--
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.
