Just do a query for the value passed from the form before you do the cfquery insert, if the queryname.recordcount GT 0, don't do the insert. You can take this much further, but in a nutshell, that'a what you would do.
Pete ----- Original Message ----- From: "Mike Miessen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 03, 2003 10:33 AM Subject: newbie school of hard knocks > I have successfully created a form to update (append) to the database. > Now that I have accomplished this fantastic feat of skill I find that I > have several duplicate entries that resulted from my testing. How can I > check for and avoid duplicate entries. Since I am new to both CF and > SQL I don't know which component to refer to for this task. > > I know you guys will point me in the right direction. > > Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
