On submitting a form, the same results are saved twice or more to a database. I'm using a stored proc, and I know it works since passing the same parameters as what shows in debug mode creates one record when run in query analyzer.
There are no extra question events that would submit the form twice. What could be causing this behavior? The only thing that might be fishy is "There is no row at position 0," but I don't know what that means.
Below are the results in debug mode:
***DYNAMIC FORMS DEBUG MODE ON***
Dynamic Forms Version: 4.10.9.27773
DotNetNuke Version: 7.0.5
Web.Config Trust Level: Unrestricted
* SQL Debug * (Parse SQL Text For Variables):usp_GetCategoryDDL '0'
* SQL Debug * (Parse SQL Text For Variables):usp_GetTax '0'
Entering Get Response To Question
Entering Get Response To Question
Entering Get Response To Question
Entering Get Response To Question
Initial Javascript:
Saving Image Responses To ViewState
File Empty:True
Image Visible:False
Preview File:
Planning to Upload New Image:
Saving Forms Responses: 8:53:22 PM
Entering Get Response To Question
Entering Get Response To Question
Entering Get Response To Question
Entering Get Response To Question
Processing Events: 8:53:22 PM
Entering Get Response To Question
Processing Additional For Hidden or Textbox Fields: DBUpdate
Processing SQL Event: Insert -8:53:22 PM
DBType: SQL
Entering Get Response To Question
Attempting to get question details
Entering Get Response To Question
Attempting to get question details
Entering Get Response To Question
Entering Get Response To Question
Attempting to get question details
Entering Get Response To Question
Entering Get Response To Question
Entering Get Response To Question
Entering Get Response To Question
Entering Get Response To Question
Entering Get Response To Question
Attempting to get question details
Entering Get Response To Question
Attempting to get question details
Entering Get Response To Question
Entering Get Response To Question
Attempting to get question details
Entering Get Response To Question
Entering Get Response To Question
Attempting to get question details
Entering Get Response To Question
Entering Get Response To Question
Entering Get Response To Question
Entering Get Response To Question
Attempting to get question details
Entering Get Response To Question
Executing SQL Event
SQL Query: usp_Add_XXXX '0', 'TTT', '', '1000', '1', '1', '1', '1', '33.33', '0', '1', '', '-1', '-1', '', '1', '3', '', '', '', '2', ''
Failure URL Redirect (Optional):
Executing SQL Next Step
SQL Error Caught: There is no row at position 0.
*** Ending Debug Mode for Dynamic Forms ***
Entering Get Response To Question
Firing Form Submission From Question Event:VariationButtonToSubmitForm
Would be submitting the form from a question event.
Thanks.