I'm trying to call a Stored Procedure in a SelectCommand on the Edit portion of an XMod Pro Form item. For some reason, the Form does not seem to be passing the parameter to the stored procedure. If I insert the raw SQL into the SelectCommand, everything works as it should. I am using the exact same stored procedure in the DetailView on the Template passing the same parameter and on the template,
Hi, I know how to pass parameters to stored procedures on a form that has fields for input. In this case, I want to pass [[User:Email]] to the stored procedure for inserting a record from my form. How can I do this? In other words, I don't need a field for Email - I just want to pass the value to the stored procedure.
Hi. I need to run a stored procedure after a user has registered via the (AddUser) action, and I need to pass the UserID token to the stored procedure. Traditionally in XMP, you can call a stored procedure from the (SubmitCommand) statement. However, since (AddUser) only runs after (SubmitCommmand), the UserID token is unavailable to SubmitCommand. Does anyone have any ideas about how to approach
When running the following stored procedure within SQL Server I get no data. ALTER PROCEDURE dbo.sProc_TotalProjBudgAmt @TotalProjBudgAmt decimal(38, 2) OUTPUT AS BEGIN SELECT @TotalProjBudgAmt = SUM(P.projBudgAmt) FROM dbo.tbl_Projects P END If I run just the select statement as follows, I get my total project budg amount. SELECT SUM(P.projBudgAmt) AS TotalBudgAmt FROM dbo.tbl_Projects P
I have a form width this submit command: This stored returns a parameter width an error message. I tried to display this message on Addsuccesstemplate: S'han afegit els usuaris de la llista excepte els següents usuaris: [[errors]] But [[errors]] is ever empty. ¿What must I do to display the returned value on errors parameter ?
I have a working stored procedure in sql that accepts a single parameter of @StateProvince which does work. From xmod pro I can execute the stored procedure and return all the values. The code below is an attempt to filter the results to just one state. If I can get this working I can move on to creating a prepopulated dropdown and pass the dropdown value with an onchange event. The main issue is