>OLEDB Error Code = 3621 
>The statement has been terminated. 
>
>
>SQL = "Insert into Sp_Signup(Email,C_Date) Values
> ('[EMAIL PROTECTED]','12/02/02')" 
>Data Source = "MFXSP" 
>

Have you tried running that query in Enterprise Manager?  My guess is that the problem 
is with the date value.  What's the datatype for C_Date?  

You might want to look into using cfqueryparam for those inserted values.

Scott
--------------------------------
Scott Brady
http://www.scottbrady.net/
 
             
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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

Reply via email to