how to access item from python sql select

Question

I am trying to get a random row from a SQL SELECT query:

    SQL = 'SELECT * FROM tblQuestion'
    cursor = Databaseconnector.SELECT(SQL)
    rows = cursor.fetchall()

    rand = random.random(0,10)
    pprint.pprint(rows)

    row = rows(rand)

However, it complains that:

    Type Error: List object is not callable

on the final line

eumiro · Accepted Answer · 2013-02-20 11:33:01Z

3

Use this:

row = random.choice(rows)

which will select a random element from the list rows.

Or check whether you can select directly a random row:

SELECT * FROM tblQuestion ORDER BY RAND() LIMIT 1

answered Feb 20, 2013 at 11:33

eumiro

214k36 gold badges307 silver badges264 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to access item from python sql select

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related