<cfoutput>
<cfquery ...>
SELECT Email
FROM table
</cfquery>
<cfoutput query="query">
#Email#<br>
</cfoutput>
</cfoutput>
In cf5 having a output nested in side of the an output would throw an error.
If CFMX it does a strange form of looping.
MB
Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com <http://www.vividmedia.com/>
608.270.9770
_____
From: Todd [mailto:[EMAIL PROTECTED]
Sent: Friday, September 10, 2004 3:29 PM
To: CF-Talk
Subject: doubling E-mail
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]