title: Strange problem with nvarchar(max) fields and Classic ASP
body: <p>I'm working on a Classic ASP (VBScript) site that's running on a <strong>Windows 2008</strong> server with <strong>IIS7</strong> and hitting a <strong>SQL Server 2008</strong> database and I'm seeing some strange behavior that seems to be specific to fields that are of type <strong>nvarchar(max)</strong>.</p>
  
  <p>I have this simple bit of code that loops over some query results and tries to print out the title field twice</p>
  
  <pre><code>rs.open "SELECT * FROM thing", dbConnection
  
  do while not rs.eof
      response.write "(" &amp; rs("title") &amp; ")" &amp; "(" &amp; rs("title") &amp; ")" &amp; "&lt;br /&gt;"
      rs.movenext
  loop
  </code></pre>
  
  <p>The first time I use <code>rs("title")</code>, I get the value back.  Any time after the first time in that loop, <code>rs("title")</code> returns a blank value.</p>
  
  <p>Again, this only seems to happen with the <strong>nvarchar(max)</strong> fields.</p>
  
  <p>Can anyone shed any light on this behavior and how to get around it?</p>