> Also, totally unrelated, I'm experimenting with the sqlite3 binding. I > couldn't get the MySQL-binding to work (it has something to do with my > libraries), but sqlite3 sort of works. Inserts work perfectly, but > when I do a "asList(myTable);" it gives the following error: > > RUNNING QUERY: > SELECT Table__g1.word AS word, Table__g1.meaning AS meaning, > Table__g1.id AS id FROM definitions AS Table__g1 > *** Error: Sqlite3.RangeError(0, 0) > > However, the same query works perfectly when issued from the sqlite3- > console.
Hi, I remember what the problem was. What version of ocaml-sqlite3 are you using? Apparently the C Sqlite3 interface has changed and the current version (1.1.0) of ocaml-sqlite3 use the new, improved one. The old interface was flaky concerning retrieving column names from the DB when the result is empty: I'd expect to see the range error above, whereas the new interface should avoid this. There used to be no way to fix this but the new interface claims to. If you're using an old version, upgrade & see if that helps. If the new version has the same problem, let me know (sample Links code/db file duplicating the problem would help). --James _______________________________________________ links-users mailing list [email protected] http://lists.inf.ed.ac.uk/mailman/listinfo/links-users -- The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336.
