hot to apply "not equal"

[HongKongSunny]

my query is like that:

<cfquery name="CheckEmail" datasource="Dating">
Select Email From MemberMain Where MemberID <> #Session.MemberID#
</cfquery>


however the output still come with that record, so what's wrong with me?

[mxstu]

If #Session.MemberID# = 3 and your table contains:

MemberID
1
2
3
4

Your query should return the emails for MemberID's 1,2 and 4. If this is not correct, what results do you want?

[Dan Bracuk]

Could be that two records have the same email. To check, do this

select email, count(email)
from membermain
group by email
having count(email) >1

[HongKongSunny]

mxtsu:

<cfquery name="CheckEmail" datasource="Dating">
Select Email From MemberMain Where MemberID <> #Session.MemberID#
</cfquery>

what i want is when member update their email , doesn't want duplicate email,
but if the member doesn't change the email, it also said that the email was
used, even belongs to the sae person

[mxstu]

Then you also need to check the email address:

Select Email
From MemberMain
Where Email = '#form.newEmailAddress#' AND
MemberID <> #Session.MemberID#

[HongKongSunny]

mxtsu,
thanks i think i didn't use "And"