3 Replies Latest reply on May 12, 2009 11:06 AM by new_to_flex

    Can I run a query using "len(...)" (build in SQL) function?

    new_to_flex

      Currently I'm getting an error:

      SQLError: 'Error #3115: SQL Error.', details:'no such function: 'Len'', operation:'execute', detailID:'2094'

       

      Query (pretty simple):

      SELECT id, term FROM terms_table WHERE term LIKE :tmpTerm ORDER BY LEN(term);

       

      Query works fine on SQLite admin interface - QA.

       

      Any idea why I get an error msg?