Sounds like you do not have a unique primary key, or you are not using it in your select. You may have 100 Janes in your database, but if you want to get this particular Jane's info, you need to select her by the primary key of that table.
Just a guess... ~Brad -----Original Message----- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 12:10 PM To: CF-Talk Subject: duplicate name output 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:253528 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
