It looks like your query is returning multiple records and then your cfoutput is looping through the query, so for each record it is displaying the from_name. You can either change the query to Select DISTINCT from_name (which should return 1 record) OR you can change your cfoutput to just <cfoutput> and omit the query part and it will just display the first record's from_name.
Steve LaBadie wrote: > I have a form and recording the info in a database. The functionality > works great, even send confirmation email. The issue I am having is the > output page duplicates same names. My output page basically says > > > > Thank you #form_name# > > Your email has be sent to #to_name" > > Etc. > > > > If the from_name is duplicated in the database the output is > > > > Thank you jane jane jane > > > > My Code: > > > > <cfinclude template="Common.cfm"> > > <cfset FileName="Send_Confirmation.cfm"> > > <cfquery datasource="tellafriend" name="confirm"> > > SELECT from_name > > from tellafriend_log > > WHERE log_id = log_id > > </cfquery> > > <html> > > <head> > > <title>TellAFriend</title> > > </head> > > <body background="images/bg.jpg"> > > > > Your Message Was Sent.<cfoutput > query="confirm">#confirm.from_name#</cfoutput></font></p> > > > > <table> > > <tr><td valign="top" align="center"><cfinclude > template="Send_Confirmation_Confirmation_Show.cfm"></td></tr> > > </table> > > </body> > > </html> > > > > > > Steve LaBadie, Web Manager > East Stroudsburg University > 200 Prospect St. > East Stroudsburg, Pa 18301 > 570-422-3999 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > http://www.esu.edu <http://www3.esu.edu> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
