Is perhaps, the email a primary key and you are inserting a duplicate value?
http://www.sqlmag.com/forums/messageview.cfm?catid=9&threadid=8008 Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -----Original Message----- From: michael firth [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:29 AM To: CF-Talk Subject: Re: OLEDB Error Code = 3621 I tryed renaming the table and that didnt seem to work. Plus also the C_Date is a nvarchar field, but what I tryed to do was run the query without the field and still got the oledb error code. Also I did run the query in query analyzer and it worked just fine. Second, I tryed changing the datasource to odbc, but the same error is occuring. Mike --------------------------------- Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm