Re: repeat record in query

[daniel kessler]

Well I removed query vars until I found the one causing the problem.  It appears that when Form.address is empty, which I supposed would be empty quotes '', it doesn't seem to query it correctly, so while there may be a John.P.Jones at '' address, it returns 0 records when I add to the Query:   

address='#Form.address#'

>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>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---