web design malta, dnn, dotnetnuke, website design, seo

Follow DotNetMushroom on TwitterFollow DotNetMushroom on LinkedIN
 

Community Forum

Free Community Support

Please note that this is a Community Forum - meaning that forum posts will be answered by members of the DotNetMushroom Community and occasionally by DotNetMushroom employees at their own discretion. For Critical Suppport, kindly refer to our Priority Support Tickets
Forums > DNM RAD > DNM RAD General Discussion
Subject: Save Record, Call Stored Procedure & Navigate
Prev Next
You are not authorized to post a reply.

AuthorMessages
Brian MannUser is Offline

Posts:3

06 Sep 2010 9:20 AM Alert 
Hi I have a problem with the stored procedures. I have a button that saves staff leave record to a table which works fine by itself when run - it saves record and returns to calling page. Expanding on this Save action - I wanted to also exec a stored procedure. Problem is stored proc did not have any parameters and caused error in DNM system (see below) - had to create a fake parameter in stored proc and make DNM pass fake parameter - can you check your code to see if it allows for no parameters in calling stored procs. When I run the save to leave table by itself it works. When I just just make form call stored procedure it works (i.e. not the save event) it works. Put both together in a Save, Call Stored Proc and Navigate back to caller it errors below:

I am not using the most current 1.4 version with latest calendar.

Latest error:"
DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot find column [dnm_sid]. ---> System.Data.EvaluateException: Cannot find column [dnm_sid]. at Holistic.DNN.Modules.DotNetMushroom.DNMButton.SaveDataReturnPk() at Holistic.DNN.Modules.DotNetMushroom.DNMButton.SaveCallStoredProcedureNavigate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

Cheers
Brian Mann
Melbourne. Australia
Luke RoccoUser is Offline

Posts:294

13 Sep 2010 3:05 PM Alert 
Hi Brian,

We have managed to solve the No Parameter issue when calling a stored procedure, however we could not replicate your latest error. Could you please update your installation to the latest version of RAD, and let us know if it manages to resolve the issue.

Regards,

Luwk
You are not authorized to post a reply.
Forums > DNM RAD > DNM RAD General Discussion > Save Record, Call Stored Procedure & Navigate


“
DotNetMushroom offers
DotNetNuke © (DNN) based web
design in Malta and Worldwide
”
Copyright (c) 2008 - 2012

Holistic IT Group

web design malta, dnn, dotnetnuke, website design, seo