Pulling wrong value from Dyn Reg
Last Post 11-04-2008 04:16 PM by Domenic Vitale. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Domenic VitaleUser is Offline
going with the flow
going with the flow
Posts:32
Avatar

--
11-03-2008 04:47 AM

    Hi I am trying to pull a value from Dynamic Registration into Dynamic User Directory.  I was succussful in pulling the value over but it's not the display I want.

    For example, the combo box on Dyn Reg is the following:

    SELECT Users.DisplayName as QuestionOption, Users.UserID as QuestionOptionValue, UserRoles.RoleID, Roles.RoleID, Roles.PortalID FROM Users, UserRoles, Roles
    WHERE Users.UserID = UserRoles.UserID AND UserRoles.RoleID = Roles.RoleID AND UserRoles.RoleID = 2 AND Roles.PortalID = 0
    ORDER BY Users.LastName

    I guess my problems derives from this.  The Dyn Reg works exactly like I want it to.. however, when I bring the value over to Dyn User Directory I get the UserID value instead of the display name.

    i.e. - I get the value 10 instead of Display Name.

    Any suggestions?  Thanks.

     

     

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    11-04-2008 10:09 AM
    Could you pull in the Users.DisplayName and Users.DisplayName as QuestionOptionValue instead of saving the userID? IS this a seperate field from the main users Display Name?
    Domenic VitaleUser is Offline
    going with the flow
    going with the flow
    Posts:32
    Avatar

    --
    11-04-2008 04:16 PM

    Works like a charm Chad... I don't know what I was thinking.  I appreciate the help.  Thanks!



    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi