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. :(