Hi there,
I have a querystring like this:
d=ART-Arts_Arts&d=ART-Design_Design I am trying to loop through the values, split on the "_" symbol (the part of the value before the "_" is for internal use, and the part after the "_" is friendly text used for displaying info to the user).  If I try to do this, it seems to loop through every letter like A, r, t instead of the whole word like Art.
So, this code:
If Request.QueryString("d") <> "" Then sql = sql & " AND (" For Each Item In Request.QueryString("d") sql = sql & " tbl_OutlookCategories.DisciplineID LIKE '" & Split(Item, "_")(0) & "'" If z < Request.QueryString("d").Count Then sql = sql & " OR " Else sql = sql & " ) " End If ...

Go to the complete details ...