title: ColdFusion9 and scripted components and hql syntax
body: <p>How can this be rewritten using the new scripting syntax along with the hibernate query language in CF9?</p>
  
  <pre><code>&lt;cfcomponent output="no"&gt;
  &lt;cffunction name="Login" output="no"&gt;
      &lt;cfargument name="UsrName"&gt;
      &lt;cfargument name="UsrPassword"&gt;
  
      &lt;cfquery name="local.qry"&gt;
      SELECT * FROM UsrView
      WHERE UsrName = &lt;cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.UsrName#"&gt;
      AND UsrPassword = &lt;cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.UsrPassword#"&gt;
      &lt;/cfquery&gt;
      &lt;cfreturn local.qry&gt;
  &lt;/cffunction&gt;
  &lt;/cfcomponent&gt;
  </code></pre>