How to use LIKE query in sqlite & iPhone
        Posted  
        
            by 4thSpace
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by 4thSpace
        
        
        
        Published on 2009-12-25T00:54:00Z
        Indexed on 
            2010/04/14
            1:03 UTC
        
        
        Read the original article
        Hit count: 573
        
I'm using the following for a LIKE query. Is this technique for LIKE correct?
selectstmtSearch = nil;
if(selectstmtSearch == nil){
  const char *sql = "SELECT col1, col2 FROM table1 t1 JOIN table2 t2 ON t1.cityid = t2.cityid where t1.cityname like ?001 order by t1.cityname";
  if(sqlite3_prepare_v2(databaseSearch, sql, -1, &selectstmtSearch, NULL) == SQLITE_OK) 
  {
     sqlite3_bind_text(selectstmtSearch, 1, [[NSString stringWithFormat:@"%%%@%%", searchText] UTF8String], -1, SQLITE_TRANSIENT);
  }
}
The problem I'm having is after a few uses of this, I get an error 14 on sqlite3_open(), which is unable to open database. If I replace the LIKE with something such as:
SELECT col1, col2 
  FROM table1 t1  
  JOIN table2 t2 ON t1.cityid = t2.cityid 
 where t1.cityname = ? 
order by t1.cityname
It works fine. I do open/close the DB before after the above code. Is there a way to troubleshoot exactly why the database can't be opened and what its relationship to my LIKE syntax is?
© Stack Overflow or respective owner