Share

Simple MS SQL Python extension module

The forum address has changed, you have been automatically redirected. Please update any bookmarks to use the new URL.

Subscribe

New bug in 1.0 or am I doing something wrong?

You are viewing a single message from this topic. View all messages.

  1. 2009-04-02 14:12:37 UTC
    There is no error message given, except by the code I posted...
    The formatting got all goofed up by the post... But here:

    newgamequerry = "SELECT TOP 1 Word FROM WordGame where choosable = 1 ORDER BY NEWID(); "
    cur.execute(newgamequerry )
    listing = cur.fetchall()

    listing contains 1 row, the randomly requested word.

    Then, that word is used in a new querry:

    querry = "Select word from WordGame where Word = '" + str(x[0]) + "'";
    cur.execute(querry)

    Which always contains zero rows... There is no error message given by pymssql. :(

< Previous | 1 | Next >

Add a Reply

This forum does not allow anonymous participation.

Log in to add a reply. Not registered? Create an account to participate and receive email updates when replies are posted to this topic.