Author: gadall | Posted on: 9/2/2008 11:30:28 AM | Views : 386

 I need to use  Membership.GetUser(User.Identity.Name.ToString).ProviderUserKey as the value for a where clause in an outer join.
SelectCommand="SELECT DISTINCT Busman.ID, Busman.contactOrgName, Busman.contactName, Busman.contactDesignation, Busman.contactTel, Busman.contactFax, Busman.contactEmail, Busman.contactCountry, Busman.Motivation, Scores.MotivationScore, Busman.Criteria_1, Scores.Criteria1, Busman.Criteria_2, Scores.Criteria2, Busman.Criteria_3, Scores.Criteria3, Busman.Criteria_4, Scores.Criteria4, Busman.Criteria_5, Scores.Criteria5, Busman.Criteria_6, Scores.Criteria6, Busman.Criteria_7, Scores.Criteria7, Busman.Criteria_8, Scores.Criteria8 FROM Busman LEFT OUTER JOIN Scores ON Busman.ID = Scores.NomID WHERE (Busman.ID = @ID) AND (Scores.JudgeID ='' OR Scores.JudgeID = @JudgeID)"
 The @JudgeID in the select command above, my problem is that beign the outer join table, there are times when the outer table won't have matchi ...

Go to the complete details ...