I thought of that, even though I take care not to insert trailing whitespace into text fields. So I printed out Len(email).
18 [EMAIL PROTECTED] Tim Jones 18 [EMAIL PROTECTED] Timothy G. Jones Jim ----- Original Message ----- From: "Jason Miller" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 6:24 PM Subject: Re: OT: Problem with DISTINCT() > That happened to me too - then I found out it was trailing white > spaces.. try trimming the white spaces > > > > Jim McAtee wrote: > > >Any ideas why I might be seeing duplicate email addresses in the dataset > >returned by this simple query (Access 97 via ODBC)? > > > ><cfquery name="r" datasource="#dsn#"> > >SELECT DISTINCT(email), name > >FROM table1 > >WHERE status = 'A' > > AND email <> '' > ></cfquery> > > > >In the output, I'm seeing stuff like: > > > >[EMAIL PROTECTED] Bob Smith > >[EMAIL PROTECTED] B. Smith > > > >The DISTINCT() operates on only the email column in this query, correct? > > > >Jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
