title: Adding Select All to dropdown
body: <p>This is my query:</p>
  
  <pre><code> &lt;cfquery name="qry" datasource="#variables.staffDs#"&gt;
    SELECT
      firstname + ' ' + surname name, userid, mobileno, extension
    FROM
      currentstaff
    WHERE
      (mobileno IS NOT NULL OR
       Left(LTrim(extension), 2) = '07')
   &lt;/cfquery&gt;
  </code></pre>
  
  <p>This is my ColdFusion dropdown box:</p>
  
  <pre><code>  &lt;select name="to" id="to"&gt;
    &lt;option value=""&gt; -- Select -- &lt;/option&gt;
    &lt;option style="font-weight: bold" value=""&gt;Send to All&lt;/option&gt;
    &lt;cfoutput query="people"&gt;
      &lt;option value="#qry.userid#"&gt;#qry.name#&lt;/option&gt;
    &lt;/cfoutput&gt;
    &lt;/select&gt;
  </code></pre>
  
  <p>The names of all people are displayed in the dropdown box list.</p>
  
  <p>What I'd like to do is add an option at the top of the dropdown box to 'Sent to All' to select all users and I'm not sure how to do this.</p>
  
  <p>I'd like to incorporate any extra SQL I might need into my current query, if this is necessary.</p>