Nevermind. It just started working again. The RecordCount dropped back to
1, The cfdump showed the contents for one record and the E-mail address
stopped doubling. That was the strangest thing.
Thanks anyway.
----- Original Message -----
From: "Lawrence Ng" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 10, 2004 4:31 PM
Subject: Re: doubling E-mail
> make sure u qualify the query to be more specific.
>
> >>> [EMAIL PROTECTED] 9/10/2004 1:28:44 PM >>>
> I have a query that pulls out an E-mail address. Then I loop through
> the query and output the E-mail addresses. When it outputs the address
> it doubles it up.
>
> For example:
>
> <cfquery ...>
> SELECT Email
> FROM table
> </cfquery>
>
> <cfoutput query="query">
> #Email#<br>
> </cfoutput>
>
> The results look like this:
>
> [EMAIL PROTECTED]@example.com
>
> The query.RecordCount says there are 2 records. This is odd,
> considering that when I run the exact same query in the MySQL Control
> Center, it returns only one record. Thinking that might have something
> to do with it in some odd way, I tried this:
>
> <cfoutput query="query">
> #Email#<cfabort>
> </cfoutput>
>
> It still outputs [EMAIL PROTECTED]@example.com
>
> If I output Email outside of the loop, it shows correctly.
>
> Anyone have any ideas?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- doubling E-mail Todd
- RE: doubling E-mail Mark W. Breneman
- Re: doubling E-mail Lawrence Ng
- Re: doubling E-mail Todd
- Re: doubling E-mail joe velez
- RE: doubling E-mail Patrick McGeehan