User Profile

Collapse

Profile Sidebar

Collapse
OggVorbis
OggVorbis
Last Activity: Oct 1 '08, 09:00 AM
Joined: Sep 30 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • OggVorbis
    replied to 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.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!...
    See more | Go to post

    Leave a comment:


  • OggVorbis
    started a topic pySqlite cur.executescript problem

    pySqlite cur.executescript problem

    Hello
    I'm using pySqlite and can return data using SELECT statement in SQLite
    ie
    Code:
    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:
    Code:
    cursor.executescript ('select * from work where nkey <=9;select * from work where nkey>94 and
    ...
    See more | Go to post
No activity results to display
Show More
Working...