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:253526 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
