title: Parameterized query in Classic Asp
body: <p>My db access code is like following:</p>
  
  <pre><code>set recordset = Server.CReateObject("ADODB.Recordset")
  set cmd1  = Server.CreateObject("ADODB.Command")
  cmd1.ActiveConnection = Conn //connection object already created
  cmd1.CommandText = "SELECT * FROM lbr_catmaster where catname = ?"
  cmd1.CommandType = adCmdText
  set prm = cmd1.CreateParameter("@prm", 200, 1,200 , "development")
  cmd1.Parameters.Append prm
  set recordset = cmd1.Execute
  </code></pre>
  
  <p>But there is no db hit going. Please help with this. I am using sql server 2005.</p>
  
  <p>Thanks.</p>