title: INSERT ALL without a select statement?
body: <p>Hope someone can help me. I want to add many records into a table from a statement I build.
  For example:</p>
  
  <pre><code>ProjectSQL = "INSERT ALL "
  For each Proj in split(Request.Form("ShowProjects"))
    ProjectSQL = ProjectSQL &amp; "  INTO proj_tbl (proj_id) VALUES ('" &amp; Proj &amp; "') "
  Next
  db.Execute ProjectSQL
  
  The SQL is:
  INSERT ALL 
    INTO proj_tbl (proj_id) VALUES ('45) 
    INTO proj_tbl (proj_id) VALUES ('56) 
    INTO proj_tbl (proj_id) VALUES ('92)  
  </code></pre>
  
  <p>Oracle SQL wants a Select statement at the end. </p>
  
  <p>I don't want to hammer the database with each loop because there could be many records to add (and the dba will cut off my balls).</p>
  
  <p>Can someone tell me how to do this?</p>
  
  <p>Thanks.</p>