title: MYSQL, COUNT = 0 Error
body: <p>MYSQL newbie</p>
  
  <p>My SQL/ASP:</p>
  
  <pre><code>sQuery = "SELECT ID, Shop, Make, COUNT(*) AS iTotal From Test.Makes WHERE Shop = " &amp; s &amp; " GROUP BY Make ORDER BY Make ASC;"
  </code></pre>
  
  <p>The table contains 1 line ID=1, Shop=1, Make=Test</p>
  
  <p>When <code>s = 1</code>, <code>iTotal = 1</code> and everything runs fine, when <code>s = 0</code>, iTotal crashes the page with error '80020009'</p>
  
  <p>Is there a way of recording a 0 recordcount</p>
  
  <p>IF iTotal > 0 Then do this else do that</p>