[OggVorbis]

Hello
I'm using pySqlite and can return data using SELECT statement in SQLite
ie

Expand|Select|Wrap|Line Numbers

1. cursor.execute ('select * from work order by name,ext')

which works!

but you get an error if you try another SELECT - 'Warning: You can only execute one statement at a time'

this causes the error:

Expand|Select|Wrap|Line Numbers

1. cursor.executescript ('select * from work where nkey <=9;select * from work where nkey>94 and nkey<100;')

so I've tried using cursor.executescript with the 2 SELECTS - I don't get an error but I don't get any data either!!! (The cursor is empty?)

The 2 select statements work fine in SQLite3 as does using just one select from the above.

Can anyone help please?
Many thanks
Ogg
:)

[Strider1066]

Perhaps you could try an 'OR' statement in your WHERE clause.
eg "WHERE columnName == y OR columnName==z"

[OggVorbis]

Ha! Many thanks Strider!

I followed your suggestion and changed it to OR statements - but it still didn't work! until of course I realised that that made it a SINGLE statement again and just used cursor.execute instead of cursor.executescript.

If you have any handy links to cursor/cursor.execute docs - I'd be grateful - all I seem to find is the python docs reformatted - but word for word on various different sites!

Thanks again

Ogg
:)

[Strider1066]

I can't find much else online. I found The Definitive Guide to SqLite, (Michael Owens, Apress) very useful. It has only a few pages on Pysqlite, but the general discussion on sqlite good.
s