When I attempt to collate a prepared statement, the arguments to the collation function are the names of the column and not the values thereof.
Given a collation function of, for instance: (define-collation db "COLLATETHIS" (lambda (x y) ...)) and a prepared statement: "SELECT * FROM test ORDER BY ? COLLATE COLLATETHIS LIMIT ? OFFSET ?;" x and y in COLLATETHIS will be "id", "id" and not, say, "1", "2". ASC and DESC are similary afflicted, and don't seem to sort prepared statements; I suspect that they, too, are passed not values but column names. Looking at sqlite3.scm, it's not immediately obvious how to fix it. _______________________________________________ Chicken-hackers mailing list [email protected] http://lists.nongnu.org/mailman/listinfo/chicken-hackers
