Problem with SQLite group_concat function

[phaworth]

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