I'm trying to bombine multiple rows in my clasic ASP application

Discussion in 'C#' started by pl5904, Nov 3, 2011.

0
  1. #1
    The SQL works in in server manager, however the response.write comes up blank in the asp page sqlstr="SELECT column, Approvers = substring( ( SELECT ', ' + Approver " &_ "FROM table e2 "&_ "WHERE e2.column = e1.column FOR XML path(''), elements),2,500) "&_ "FROM table e1"&_ "WHERE column= " isRequired='Y'" Response.Write "[TD] Approvers [/TD]
    "should come bake with names seperated by ,
     
    pl5904, Nov 3, 2011 IP
  2. pl5904

    pl5904 Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    that is I'm trying to combine
     
    pl5904, Nov 3, 2011 IP