Hi,

I'm tyring to send a querystring variable to my page with DR on it.  And I can get all my other fields, Username, FirstName, etc...to populate...but I can't seem to get my Combo Box (which uses SQL to populate the choices) to pick the querystring variable.

I've made sure that my shortname matches the variable in the querystring.  And I've made sure to check to retrieve values from querystring variable for this question:

This field is attached to a custom profile field that I created using DNN Users tools for doing that.  It appears as a choice in the dropdown when I want attach to a DNN field.

Am I missing something?  Does anyone have a suggestion on how I could get this to work?

Thanks,
Jerry

Jerry, on drop down combo box using SQL query, you need to specify a where clause as well. Try this:
select SchoolName as QuestionOption, SchoolName as QuestionOptionValue from OPS_SCHOOL_LIST where columnname = '$(SA)'

Replace columnname with the name of the column from your OPS_SCHOOL_LIST table that you want to retrieve. If this works, then put in the "Order by Schoolname ASC" afterwards. -- David

Hi Jerry,

If you want to hide these fields, you cannot hide these on the question level as these are considered 'user credentials' that DNN requires.  Please take these settings out (including the do not save to db).  Then, please go to DNN Core Integration and expand the Advanced Core Integration Options.  You'll find settings there pertaining to Hide Fields.

Something else to think about:  do you not want your users to enter their own username and password?  If so, you can just select the option to Auto Create User ID, again under Advanced Core Integration.  Just remember that you still need the username & password fields on the form, it will just be hidden.  Hope that helps!

Candace

Thanks, candace that did help!  I'm not getting the error any more!

Now I'm running into a new error and hopefully you have a good suggestion....I'm running a completion event to run only on update registration using the following SQL

UPDATE Users SET DisplayName='$(NewSchool)' WHERE UsersID='$(UID)'

I'm not sure why it's not working.  I have another DR module that is tied to be default user registration module and this SQL Completion Event works on that one, so I know the syntax is correct, but I'm unsure why it's not firing when there is registration update.  Any ideas?

Thanks for your help.
Jerry

Oh...I've found it...UsersID should be UserID...now that I've switched it...it's working! 

Thanks candace and chad for all your help!

Okay..unfortnately I have one last issue with this project..(should I start a new thread?).

So I have a IndooGridView module that lists the users, and passes the querystring parameters of UserName, DisplayName, FirstName, LastName, Email, SchoolAttending(added to DNN Profile), and GradeLevel(Added to DNN Profile), and UserID. to the DR Module on another page.

The DR Module correctly sees these fields because the shortnames matches the querystring parameter sent and using Advanced Core Integration Options, I have hidden the fields I can. All the other controls are marked not to upload to database, as I have completion events to run SQL to update FirstName, LastName, Email, SchoolAttending, and GradeLevel, provided that a checkbox has been ticked for each field they want to update. This SQL updates the Users Table and the UserProfile Table.

This all works correctly when I'm logged in as the host. I've created a role to assign specific users (so they can manage user profiles) and assigned it to the pages with the IndooGrid and the DR Modules. This role has view rights only.

When I test a user account mapped to that role, the indoogrid does pass the parameters correctly and the DR does receive the parameters, but when I try to make a change to any of the fields, the DR module updates the Users and UserProfile Table of the logged in user.

It looks like DR doesn't use the passed UserID but the logged in UserID, so when the SQL completion events are firing off they are using the wrong UserID.

So what did I miss here? Will this not work?

Thanks again for your help!
Jerry

HI Jerry, let me try and understand this. So any users belonging to the role can edit other user's profile that belong to that role also by picking the IndooGrid fields and sending them as querystring over to DR for SQL updates? If this is the case, you will need to use the SQL 'DSParam1' option for the UserID. Name the shortfield in IndooGrid for UserID to 'DSParam1' and pass this querystring. In your DR form, create a hidden field called 'DSParam1' that request value from querystring and then in your SQL update statement (check our form demo 14), use something like: where UserID = '$(DSParam1)'. -- David

Hi,

The role I created can edit anyone's profile, however, I use the indoogrid to filter out those users that belong to the same school.(SchoolAttending Field) that the logged in user belongs to. So I have many schools a, b, c, d, and my user belongs to school a. The role gives the view rights to the page, but their profile filters out on the indoogrid to show them users in ther school only. For example, my user can only see user profiles that belong to school a.

I've tried what you suggested and it appears to work better. Now it's actually updating the user profile I selected, but it's still changing my current user that is logged in as well. WHen before it was only changing the current user logged in.

So I'm closer...It appears that fields mapped in the DNN core integration are overwriting my current user login info eventhough I've setup a SQL completion event to update my selected User Profile.

Is there a way to get around this?

Thanks for your help.
Jerry

UPDATE: I went to the DNN Integration and set the Recommended fields to select dynamic fields and that helped.  It's no longer overwriting my logged in user's FirstName, LastName, Email, and DisplayName.

Despite the UserID being passed as DSParam1, it's still changing my logged in user profile information along with my selected user.  Here is the SQL completion event.

UPDATE UserProfile
SET PropertyValue='$(USA)' WHERE PropertyDefinitionID='59' and UserID='$(DSParam1)

Thanks for the idea...But I'm not sure it's going to work...as you said the Update Registration acts in conjunction with the SQL completion event...I guess it depends on wheter the SQL completion events fire after the Update Registration fires.

If the Update Registration runs it's updates then the SQL Completions fires off, then this might work...it's worth testing.

What's weird is that it doesn't happen when I'm logged in as a SuperUser...it only happens when I'm logged in as User that has View Permissions to this page.