title: Assigning Variables from csv file
body: <p>I have a csv file (sample)</p>
  
  <pre><code>Firm,Code,Server
  Adsuar,BZ,RKASP01
  Ahlers,AU,RKASP02
  Andrews,CW,RKASP02
  Armbrecht,AS,RKASP02
  Barron,ZZ,RKASP01
  Beckman,BI,RKASP02
  </code></pre>
  
  <p>and am trying to find a way in vbscript to have a single select box on my website that lists the values of column A, and then populate two variables with the contents of column B and C in the same row. </p>
  
  <p>I have what I need to read the csv file and can loop through the file and echo all the contents, however I'm having some trouble finding where to go from here. Any suggestions on where I can start would be appreciated. </p>
  
  <p>The code I have currently is</p>
  
  <pre><code>Set objFSO = CreateObject("Scripting.FileSystemObject")
  Set objTextFile = objFSO.OpenTextFile("\\rkaspctl01\n$\wwwroot\dev\clients.csv", 1)
  
  do while not (objTextFile.AtEndOfStream)
    arrStr = Split(objTextFile.ReadLine, ",")
    strFirm = arrStr(0)
    strCode = arrStr(1)
    strServer = arrStr(2)
  Loop
  
  objTextFile.close
  </code></pre>
  
  <p>Thanks 
  Patrick Stoddard</p>