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
