title: Casue of SQLite Error: 'Error #3132: Data type mismatch.' in Adobe AIR
body: <pre><code>"SELECT * FROM locations 
   JOIN section_has_location ON locations.location_id = section_has_location.location_id 
   WHERE section_has_location.chapter_id =2 
     AND section_has_location.section_id=2"
  </code></pre>
  
  <p>I get the error:</p>
  
  <blockquote>
    <p>SQLError: 'Error #3132: Data type mismatch.', details:'could not convert text value to numeric value.', operation:'execute', detailID:'2300'</p>
  </blockquote>
  
  <p>These are the tables:</p>
  
  <pre><code>CREATE TABLE locations ( 
      location_id INTEGER,
      name        TEXT,
      mask_id     TEXT,
      x           REAL,
      y           REAL,
      content     TEXT,
      image_url   TEXT,
      type        TEXT 
  );
  
  CREATE TABLE section_has_location ( 
      chapter_id  INTEGER,
      section_id  INTEGER,
      location_id INTEGER 
  );
  </code></pre>
  
  <p><strong>How do I fix the query as to not cause the error?</strong></p>
  
  <p>update: I exported all the data, and imported into a new clean database. This seems to have solved that error.</p>