OT: Problem with DISTINCT()

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

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

Re: OT: Problem with DISTINCT()

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

RE: OT: Problem with DISTINCT()

McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 3:27 PM To: CF-Talk Subject: Re: OT: Problem with DISTINCT() 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