title: Removing null from a value list
body: <p>I have a query :</p>
  
  <pre><code>&lt;cfif topic NEQ ""&gt;
      &lt;cfquery name="queryTopicName" datasource="#ODBC#"&gt;
          select topic as topicName from ltbTopics where topicId in (#topic#)
      &lt;/cfquery&gt;
      &lt;cfset selectedRiskCategories = ValueList(queryTopicName.topicName)&gt;
  &lt;/cfif&gt;
  </code></pre>
  
  <p>Here the "#topic#" contains  a list  whose first value is empty, so it comes likes <strong>,,51,52,</strong> etc so it gives an error as:</p>
  
  <blockquote>
    <p>"Incorrect syntax near ','</p>
  </blockquote>
  
  <p>. <br>The error occurred on line 33", can any one help me in this how to resolve this?</p>