Re: How to insert multiple rows in SQLite Dbase

2008-04-21 Thread afandi
On Apr 1, 12:22 am, afandi <[EMAIL PROTECTED]> wrote: > On Mar 30, 4:46 am, Gerhard Häring <[EMAIL PROTECTED]> wrote: > > > > > Gabriel Genellina wrote: > > > [...] > > > and execute: > > > cur.executemany("insert into log (IP, Entr

Re: How to insert multiple rows in SQLite Dbase

2008-03-31 Thread afandi
On Mar 30, 4:46 am, Gerhard Häring <[EMAIL PROTECTED]> wrote: > Gabriel Genellina wrote: > > [...] > > and execute: > > cur.executemany("insert into log (IP, EntryDate, Requestt, ErrorCode) > > values (:ip, :date, :request, :errorcode)", values) > > It's probably worth mentioning that pysqlite's ex

How to insert multiple rows in SQLite Dbase

2008-03-28 Thread afandi
Hi, Generally, it involves SQL statement such as follow INSERT INTO (field1,field2,...fieldn) VALUES ('abc','def'...) If I have data taken from Apache Server Log,let say 100 lines which is printed output of 8 fields such as: data 1 IP: 61.5.65.101 Date: 26/Sep/2007 Time: 20:43: