Hi I have a problem trying to update and insert a new record into a table i'm using this update and insert command.
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MYSQL_ISDB %>"
ProviderName="<%$ ConnectionStrings:MYSQL_ISDB.ProviderName %>"
SelectCommand="SELECT t_diary_all.Log_ID, vrqsummary.VUpdated, vrqsummary.VWho, vrqsummary.VCompany, vrqsummary.VContact, vrqsummary.VNotes, vrqsummary.VSR, vrqsummary.VLocation, vrqsummary.VDue_Date, vrqsummary.VComplete_Flag,
t_diary_all.Updated, t_diary_all.Who, t_diary_all.Company, t_diary_all.Contact, t_diary_all.Notes, t_diary_all.SR, t_diary_all.Location, t_diary_all.Due_Date, t_diary_all.Complete_Flag FROM t_diary_all INNER JOIN vrqsummary ON t_diary_all.Log_ID = vrqsummary.Log_ID"
InsertCommand="INSERT INTO [t_diary_all] ([Log_ID], [Updated], [Who], [Company], [Contact], [Notes], [SR], [Location], [Due_Date], [Complete_Flag]) VALUES (@Log_ID, @Updated, @Who, @Company, @Contact, @Notes, @SR, @Location, @Due_Date, @Complete_Flag)"
UpdateCommand="UPDATE [t_diary_all] SET [Updated] = @Updated, [Who] = @Who, [Company] = @Company, [Contact] = @Contact, [Notes] = @Notes, [SR] = @SR, [Location] = @Location, [Due_Date] = @Due_Date, [Complete_Flag] = @Complete_Flag WHERE [Log_ID] = @Log_ID">
</asp:SqlDataSource>
This is the error message I am getting http://www.telerik.com/ClientsFiles/450229_error2.jpg