pysqlite

[Dave Harrison]

hi all,

I need to be able to flash a database with the sql def'ns I have, and it
works if I pipe my file into sqlite, but when I execute the same data as
a giant string I get no error, but the database isn't flashed.

anyone have any ideas ? Ive tried stripping out newlines, all whitespace
reduced to single spaces etc etc ...

--
Dave Harrison
Nullcube
dave@nullcube.c om

http://www.nullcube.com

[Peter Otten]

Re: pysqlite

Dave Harrison wrote:
[color=blue]
> I need to be able to flash a database with the sql def'ns I have, and it
> works if I pipe my file into sqlite, but when I execute the same data as
> a giant string I get no error, but the database isn't flashed.
>
> anyone have any ideas ? Ive tried stripping out newlines, all whitespace
> reduced to single spaces etc etc ...[/color]

Did you commit() before closing the connection?

Peter

[Heather Coppersmith]

Re: pysqlite

On Sun, 28 Mar 2004 21:59:35 +1000,
Dave Harrison <dave@nullcube. com> wrote:
[color=blue]
> I need to be able to flash a database with the sql def'ns I
> have, and it works if I pipe my file into sqlite, but when I
> execute the same data as a giant string I get no error, but the
> database isn't flashed.[/color]
[color=blue]
> anyone have any ideas ? Ive tried stripping out newlines, all
> whitespace reduced to single spaces etc etc ...[/color]

Is there a final newline on the string?

Regards,
Heather

--
Heather Coppersmith
That's not right; that's not even wrong. -- Wolfgang Pauli