title: Using ASP and INSERT INTO -
body: <p>I am trying to create a simple page that enters data in to a database and my code is below.</p>
  
  <pre><code>&lt;%@ LANGUAGE="VBSCRIPT" %&gt;
  &lt;% Option Explicit %&gt;
  &lt;!--#include FILE=dbcano.inc--&gt;
  &lt;%
  
  dim username,password,f_name,l_name,objConn,objs,query
  
  username   = Request.Form("user")
  password   = Request.Form("pass")
  f_name     = Request.Form("fname")
  l_name     = Request.Form("lname")
  
  if((f_name &lt;&gt; null) or (f_name &lt;&gt; "")) then
      response.redirect("patti_account.asp")
  else
      Set objConn = ConnectDB()
      query       = "INSERT INTO user (username,password,f_name,l_name) VALUES ('"&amp; username &amp;"','"&amp; password &amp;"','"&amp; f_name &amp;"','"&amp; l_name &amp;"')"
      Set objs    = objConn.Execute(query)
  
      Response.Redirect ("thankyou.asp")
  
  end if
  
  %&gt;
  </code></pre>
  
  <p>I am getting this error when I run my page:</p>
  
  <blockquote>
    <p>Microsoft OLE DB Provider for SQL
    Server error '80040e14'</p>
    
    <p>Incorrect syntax near the keyword
    'user'.</p>
    
    <p>create_account.asp, line 18</p>
  </blockquote>
  
  <p>I have checked everything, my field names exist and my table name is correct as well.</p>
  
  <p>Any suggestions?</p>