Register  Login  
  February 9, 2012  
Forum    
Forum Minimize
 
ForumForumDiscussionsDiscussionsSQLGridSelected...SQLGridSelected...How to pass Parameters IMC Stored ProcedureHow to pass Parameters IMC Stored Procedure
Previous Previous
 
Next Next
New Post
 8/11/2010 4:25 PM
 

I have a stored procedure that if you give it a first name and a last name it returnes a list of User Names in DNN.

i.e. exec Get_DNN_USER_SearchLastFirstName @LastName = John, @FirstName = Doe

I set up search text fields that the first and last name could be input by the user:

exec Get_DNN_USER_SearchLastFirstName @LastName = [SEARCH:Text], @FirstName = [SEARCH2:Text]

This works and displays a place to input the first and last name. The results return

UserId, First, Last, MI, Username, Email

I want to make this instance of SGSV a parent and pass UserID to a Child. I don't understand how to get this instance to associate UserId with a parameter that I can then pass to a child.

New Post
 8/18/2010 2:48 AM
 

First let me appolgize for being slow to respond -- I am currently on vacation.

In the parent module you need to enable the Parent mode of IMC in the process option section, then in the child module you need to enable the child mode of IMC. This will result in all the parent substitution parameters being passed the the child module with the keyword of Parent prepended to each parameter -- so [Search:Text] would become [Parent_Search:Text] in the child module.

Check out this example http://www.tressleworks.ca/Modules/SQ...

Hope this helps
Paul.

New Post
 8/27/2010 6:49 PM
 

Paul,

Thanks for the reply. In your example you have a drop down list in module 1. Once something is selected then it passes the value. What I need is different. I need to be able to SEARCH for an item, select it then the value of the selected item gets passed to the child module.

So I search for John Doe and it returns 3 entries. I select one of those entries and that populates the children.

Previous Previous
 
Next Next
ForumForumDiscussionsDiscussionsSQLGridSelected...SQLGridSelected...How to pass Parameters IMC Stored ProcedureHow to pass Parameters IMC Stored Procedure

Print  

  Home | Blog | Forum | Subscriptions | Free Modules | Videos   Page generated in 0.203632 seconds.
  Copyright 2010 by TressleWorks   Terms Of Use | Privacy Statement