Thank you for the tip with the numbered rows, Simon (everything worked fine in the shell) -- But I just discovered that my problem was caused by a \n character that my script failed to strip
-- Dr. Marten Düring Digital Humanities Researcher Centre Virtuel de la Connaissance sur l’Europe (CVCE) www.cvce.eu / www.cubrikproject.eu Personal website, Historical Network Research ---- On Fri, 23 Aug 2013 14:59:06 +0200 Simon Slavin <[email protected]> wrote ---- On 23 Aug 2013, at 1:48pm, m.duering <[email protected]> wrote: > However I only get one result if I run the query > SELECT * FROM nodes WHERE Netzwerk="Kaufmann" SQLite uses single quotes to surround strings. Should be: SELECT * FROM nodes WHERE Netzwerk='Kaufmann' > This works ok and I am able to import everything into the Firefox SQlite Manager and Gephi. If you're not sure your data is stored properly, please download and use the SQLite Shell Tool to examine your database. Make sure that the results of SELECT commands are what you think they should be. Other tools may be useful but only the SQLite shell tool was written by the SQLite team and is completely trustworthy. <http://www.sqlite.org/sqlite.html> <http://www.sqlite.org/download.html> I also suspect you need to redesign your data structure for long-term use. Anything that leads to numbered columns (e.g. edges 0 to 17) is usually a sign that you really need to be storing things in numbered rows instead. But your existing code should work fine. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
