Re: [sqlite] How to .import NULL values?

2005-01-24 Thread Dennis Cote
Daniele Nicolucci (Jollino) wrote: Ok, I guess I'll have to live without having an auto-increment field or find a way to fill it in the csv file with explicit values... my C skills are almost null so I don't even attempt to do that. Or I could write a simple script to generate INSERTs from csv

Re: [sqlite] How to .import NULL values?

2005-01-22 Thread Jollino
Il giorno 22 gen 2005, alle 18:53, Ulrik Petersen ha scritto: I forgot to say this about my "contribution": Of course! :) Thanks *a lot* for the patch, I will test it tomorrow. Daniele -- Daniele Nicolucci (Jollino) Photo portfolio: http://www.nicolucci.net Sarà anche vero che vivere sulla Terra

Re: [sqlite] How to .import NULL values?

2005-01-22 Thread Ulrik Petersen
Hi Daniele, Ulrik Petersen wrote: Only in sqlite-3.0.8-nullimport/: config.h Only in sqlite-3.0.8-nullimport/: config.log Only in sqlite-3.0.8-nullimport/: config.status Only in sqlite-3.0.8: doc Only in sqlite-3.0.8-nullimport/: libtool Only in sqlite-3.0.8-nullimport/: Makefile Only in

Re: [sqlite] How to .import NULL values?

2005-01-22 Thread Ulrik Petersen
Hi Daniele, Daniele Nicolucci (Jollino) wrote: Il giorno 22 gen 2005, alle 18:16, Ulrik Petersen ha scritto: As you can see, sqlite3_bind_text is used for all columns. You would have to write some ad-hoc code inside the loop that checked whether the value in azCol[i] was "null" or "NULL", and

Re: [sqlite] How to .import NULL values?

2005-01-22 Thread Jollino
Il giorno 22 gen 2005, alle 18:16, Ulrik Petersen ha scritto: As you can see, sqlite3_bind_text is used for all columns. You would have to write some ad-hoc code inside the loop that checked whether the value in azCol[i] was "null" or "NULL", and then used sqlite3_bind_null if that was the

Re: [sqlite] How to .import NULL values?

2005-01-22 Thread Ulrik Petersen
Hi Daniele, Daniele Nicolucci (Jollino) wrote: Hello, I'm using sqlite 3.0.7 on OS X and I'm having a hard time using the .import function to import data which includes NULL values. I made a test database to describe the problem. This is the schema of the table: sqlite> .schema CREATE TABLE

[sqlite] How to .import NULL values?

2005-01-22 Thread Jollino
Hello, I'm using sqlite 3.0.7 on OS X and I'm having a hard time using the .import function to import data which includes NULL values. I made a test database to describe the problem. This is the schema of the table: sqlite> .schema CREATE TABLE quest (id integer primary key default null, sesso,