title: Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dummy@.books.id' in 'where clause'
body: <p>I'm having some trouble finding out where I'm getting this error from:</p>
  
  <blockquote>
    <p>Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dummy@.books.id' in 'where clause'</p>
  </blockquote>
  
  <p>sql query  </p>
  
  <pre><code>UPDATE 
      `dummy@`.`books` 
  SET 
      `isbn` = '1234532', 
      `title` = 'cakephp blog tutorial', 
      `id` = 5, 
      `description` = 'gh', 
      `author_name` = 'andrew' 
  WHERE 
      `dummy@.books.id` = '5'
  </code></pre>
  
  <p>if i edit the record the following error has occurred</p>
  
  <p>controller function</p>
  
  <pre><code>function edit ($id = NULL){
           if (!$id &amp;&amp; empty($this-&gt;request-&gt;data)) {
            $this-&gt;Session-&gt;setFlash('Invalid Book', true);
            $this-&gt;redirect(array('action'=&gt;'index'));
         }  
  
          else {    
              $this-&gt;Book-&gt;create();
  
           $save = $this-&gt;Book-&gt;save($this-&gt;request-&gt;data);
              if($save){ 
  
                 $this-&gt;Session-&gt;setFlash('book detail edit successfully');
                 $this-&gt;redirect(array('action'=&gt;'index',$id));
                } 
         }
             if(empty($this-&gt;request-&gt;data)){               
             $this-&gt;request-&gt;data = $this-&gt;Book-&gt;read(NULL,$id);
          }           
     }
  </code></pre>
  
  <p>and  view ctp file    </p>
  
  <pre><code>&lt;?php  echo $this-&gt;Form-&gt;create('Book');?&gt;
  &lt;fieldset&gt;
      &lt;legend&gt; Edit New Book &lt;/legend&gt;
      &lt;?php
  
      echo $this-&gt;Form-&gt;input('isbn');
      echo $this-&gt;Form-&gt;input('title');
      echo $this-&gt;Form-&gt;hidden('id'); 
      echo $this-&gt;Form-&gt;input('description');
      echo $this-&gt;Form-&gt;input('author_name');
      ?&gt;
  &lt;/fieldset&gt;
  &lt;?php echo $this-&gt;Form-&gt;end('Edit Book');?&gt;
  </code></pre>