Problem with SQLite group_concat function
Posted: Tue Nov 10, 2009 7:44 pm
I am trying to execute a SELECT statement that includes the SQLite group_concat function using the revQueryDatabase function. The statement failes with a "missing database or SQL error" message. Exactly the same statement cut and pasted into either sqlite3 command line tool or the Firefix SQLite Manager extension works correctly. If I remove the group_concat from the SELECT statemnet, Rev works fine.
In the past I have similar issues with the SQLite substr function. I am beginning to think that Rev does not allow the use of SQLite functions within a SELECT statement. If that is true, it's a major oversight/problem/bug.
Has anyone else run into similar issues?
Thanks,
Pete
In the past I have similar issues with the SQLite substr function. I am beginning to think that Rev does not allow the use of SQLite functions within a SELECT statement. If that is true, it's a major oversight/problem/bug.
Has anyone else run into similar issues?
Thanks,
Pete