Do you mean "I want to be sure that there are _NO_ duplicates" ??
If so, then your <cfif ...> statement ought to read add_check.recordcount GT _1_ (not 0)
Of course you may want to know if your form fields yield 0 results.
A quick-n-dirty way to see if there are dupes would be to run 2 queries
(qry 1: select * and qry 2: select distinct *) and check the
'myquery.recordcount' for each (if the recordcounts are equal, then you
may assume that there are no dupes.
hth, -mike
Daniel Kessler <[EMAIL PROTECTED]>
07/15/2004 02:00 PM
Please respond to cf-talk
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject: repeat record in query
I have an alumni database and I want to be sure that there are
duplicate people. I have alot of information to do a compare, but I
don't want to limit it to first name/last name. Also, the query that
I've been doing seems say there's a duplicate when there isn't so I
wanted to be sure I was doing this correct.
<cfquery name="add_check" datasource="ch">
SELECT firstname,middlename,lastname,address FROM alumni_contacts
WHERE firstname = '#Form.firstname#' AND middlename =
'#Form.middlename#' AND lastname = '#Form.lastname#' AND
address='#Form.address#'
</cfquery>
<cfif add_check.recordcount GT 0>
<cflocation url=""> </cfif>
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
