zeal <zealx...@hotmail.com> wrote: > Dear sqlite user group, > > i just run a sqlstmt like: >>>> conn=sqlite3.connect("c:/tmp/tree_db.txt") >>>> conn.execute("select rdn, group_concat(child_rdn) as child from >>>> cm_tree group by rdn") > Traceback (most recent call last): > File "<interactive input>", line 1, in <module> > OperationalError: no such function: group_concat > > is there model that should be installed but i am missed?
group_concat is a fairly recent addition to SQLite. My guess is, you are running a version of SQLite that predates it. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users