Questions

Questions Filter:
All Unanswered Answered My Questions My Answers
Tag Filter:

stored procedures and output parameters

(I'll post a fiddle) I've created a stored procedure that averages columns from a table (external from DNN). I've tested it outside of DNN and I can get the results I expected. Then I used this example: http://dnndev.com/help/xmodpro/default.htm#tokens_... To construct my template. I think I have everything configured properly, but I get the error: Error MESSAGE: Object reference not set to an ins
output parametersstored procedures
0 votes
5 responses
1394 views
Jen Sharp asked Jun 24, 2016 active Aug 13, 2019

Odd errors when attemping to use a Stored Procedure

Hi again, I'm trying to modify a form to trigger a stored procedure upon submit. I have written up a stored procedure and tested it by running the EXEC command from within SQL Management Studio. So it appears to be working. However, after I modified the form to use the stored procedure, I keep getting this error: Procedure or function SP_Contact_Create has too many arguments specified." I've been
SQLstored procedures
0 votes
1 responses
2271 views
David Puffenberger asked Sep 20, 2018 active Sep 21, 2018

SubmitCommands

I've tried everything to send parameters to a stored procedure within an edit form. Nothing works. I tried specifying the data types, values with single parenthesis, values without parenthesis. Nothing works. The data types of the parameters are Int32 and Decimal. Simply doesn't work even with hard coded values.
Parametersstored proceduresSubmitCommands
0 votes
0 responses
1905 views
Dana Armstrong asked Aug 23, 2017 active Aug 23, 2017

Example for SP in forms please

OK...I have search through everything I can find.... I found an example of calling a Stored Procedure in the add form...works just fine. I cannot find an example of calling an SP from an edit for for both the selectcommand and the updatecommand sections. There must be some blasted magical combination of single or double quotes while standing on your head and typing only with your left hand or some
formsstored procedures
1 votes
3 responses
1554 views
Roy Barrow asked Jan 5, 2015 active Jan 18, 2015

Getting Good Answers

How do you get good answers to your questions?   Ask good questions. That means:

  1. Good Titles: Give your question a concise but informative title. Rather than "Email Forms", use "Sending multiple emails from forms".
  2. Do Your Research: Check out the XMod Pro help file, the XMod Pro Guide on this site, do a search in this Answers forum. Members are friendly and more than happy to help, but it's good etiquette to show you've done your homework.
  3. Is It Answerable? Your question should be practical and answerable. Provide clear and accurate details about your specific problem. Be sure to include all the pertinent information or links to images and examples. 
  4. Show Your Appreciation: If someone correctly answers your question, come back and ACCEPT the answer. That gives them points and helps others know it was a correct answer. If members know you'll accept an answer, they'll be more likely to spend time on your next question(s).