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.executes cript.
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!...
User Profile
Collapse
-
pySqlite cur.executescript problem
Hello
I'm using pySqlite and can return data using SELECT statement in SQLite
iewhich works!Code:cursor.execute ('select * from work order by name,ext')
but you get an error if you try another SELECT - 'Warning: You can only execute one statement at a time'
this causes the error:
...Code:cursor.executescript ('select * from work where nkey <=9;select * from work where nkey>94 and
No activity results to display
Show More
Leave a comment: