[sqlite] Python -> Sqlite3 import, can't retrieve values in the last column

Hi all, this is my first project using Sqlite3 so I might have done something silly along the way. I can not run queries for the last columns of my tables. I either get only the very last row or nothing where there should be hundreds of entries which match the query. Here is what I did: I r

Re: [sqlite] Python -> Sqlite3 import, can't retrieve values in the last column

On 23 Aug 2013, at 1:48pm, m.duering 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 imp

Re: [sqlite] Python -> Sqlite3 import, can't retrieve values in the last column

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)