2 Replies Latest reply on May 29, 2009 4:53 PM by de5a1n7

    SQLite, problem with parameter

    de5a1n7

      Hello,

       

      Does anyone know what's wrong with the following sql statement?

       

      var GetItemByNameSql:String = "SELECT id FROM items WHERE name LIKE '%:name%'";

       

      I've got an error saying that parameter :name is not in the SQL.

       

      when i remove the % symbol it is fine but then the statement will only return the whole word match.

       

      Does this mean i cannot use % together with parameter?

       

      Thanks.