title: SQL data not showing two columns on site
body: <p>I've got a DB connection to my SQL Server on Azure. Two columns are showing on the page but not showing the other 2. Columns are company name and further details</p>
  
  <p>Company Name is standard business name </p>
  
  <p>Further Details stores URLs to more information </p>
  
  <p>I've tried the SQL statement in SQL Management and it displays data what should be shown.</p>
  
  <p>I've checked the parameters of the column, they're both nvarchar(Max) it shows as -1 when clicking to modify the size of the column. Does this mean it has unlimited size?</p>
  
  <p>The file type is Classic ASP with inline CSS and HTML inside. </p>
  
  <p>Below is what is being called in the database. </p>
  
  <pre><code>&lt;%
  Session.LCID=2057
  
  Dim connpiudb, rspiudata, strSQL, fldThis, strSQL2, strSQL3, strcategory
  
  strcategory = Request.querystring("category")
  
  Set connpiudb = Server.CreateObject("ADODB.Connection")
  Set rspiudata = Server.CreateObject("ADODB.Recordset")
  
  strSQL = "SELECT companyname, courtnumber, cronumber, furtherdetails FROM piudata WHERE category LIKE '" &amp; strCategory &amp; "%' Order by companyname"
   strValue = Request.QueryString(&lt;%= rspiudata.Fields("companyname") %&gt;)
  
  response.write strSQL
  response.write strValue
  
  &lt;!-- strSQL = "SELECT companyname , courtnumber , cronumber, furtherdetails FROM piudata WHERE category LIKE '%c%' Order by companyname" --&gt;
  
  connpiudb.Open strConnect
  rspiudata.open strSQL, connpiudb
  %&gt;
  </code></pre>
  
  <p>Below is how the database is stored in the HTML table. </p>
  
  <pre><code>&lt;!--content start--&gt;
  
  &lt;FONT FACE="Arial" size="2"&gt;
  
  &lt;TABLE BORDER="0" cellpadding="2" width="60%"&gt;&lt;TR&gt;
  
    &lt;%
    Do Until rspiudata.EOF
    %&gt;
    &lt;TR&gt;&lt;TD width="40%"&gt;&lt;B&gt;Company Name:&lt;/B&gt;&lt;/TD&gt;&lt;TD width="60%"&gt;&lt;%= rspiudata.Fields("companyname") %&gt;&lt;/TD&gt;&lt;/TR&gt;  
    &lt;TR&gt;&lt;TD width="40%"&gt;&lt;B&gt;Further Details:&lt;/B&gt;&lt;/TD&gt;&lt;TD width="60%"&gt;&lt;%=rspiudata.Fields("furtherdetails") %&gt;&lt;/TD&gt;&lt;/TR&gt;
    &lt;TR&gt;&lt;TD width="40%"&gt;&lt;B&gt;Court Number:&lt;/B&gt;&lt;/TD&gt;&lt;TD width="60%"&gt;&lt;%= rspiudata.Fields("courtnumber") %&gt;&lt;/TD&gt;&lt;/TR&gt;
    &lt;TR&gt;&lt;TD width="40%"&gt;&lt;B&gt;Company Registered Number:&lt;/B&gt;&lt;/TD&gt;&lt;TD width="60%"&gt;&lt;%= rspiudata.Fields("cronumber") %&gt;&lt;/TD&gt;&lt;/TR&gt;
    &lt;TR&gt;&lt;TD width="100%" colspan="2"&gt;&lt;HR&gt;&lt;/TD&gt;&lt;/TR&gt;
    &lt;%
    rspiudata.movenext
    Loop
  
    rspiudata.Close
    Set rspiudata = Nothing
    connpiudb.close
    %&gt;
  &lt;/TABLE&gt;
  </code></pre>
  
  <p>I am struggling to understand what the actual issue is. Only thing I've thought of is that the columns sizes default to -1 when setting it as MAX or that Classic ASP does not support NVARCHAR(max)</p>
  
  <p>Any help will be great.</p>