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
<slav...@bigfraud.org> wrote ----
On 23 Aug 2013, at 1:48pm, m.duering <m.duer...@zoho.com> 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
