pySqlite cur.executescript problem

Hello
I'm using pySqlite and can return data using SELECT statement in SQLite
ie 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:

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
:)

re: pySqlite cur.executescript problem

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

re: pySqlite cur.executescript problem

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
:)

re: pySqlite cur.executescript problem

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