Hi so I am displaying 4 DropDownList's on my website and have a question about values included within a sqlQuery.AppendIs there a different way I need to write this to include (2) OR statements? I have multiple schoolid's and an Away or Home state that I need to reference. I wasn't sure if the brackets needed to be changed at all with (2) OR + (2) AND statements. Any help is appreciated. Thanks!sqlQuery.Append("WHERE HomeSchoolID <> 597 AND HomeSchoolID = '" + Convert.ToString(Session["schoolid"]) + "' OR AwaySchoolID = '" + Convert.ToString(Session["schoolid"]) + "' AND (SC.state='" + Convert.ToString(Session["state"]) + "' OR SC2.state='" + Convert.ToString(Session["state"]) + "') ");
Question about sqlQuery.Append
Posted - 2010-04-13 : 12:50:24
