Re: [PyQt] returning SQL result as ordinary python string?

2012-05-03 Thread Linos
El 03/05/12 16:02, Andrew Suffield escribió: > On Thu, May 03, 2012 at 08:15:26AM -0400, Mark Mordeca wrote: >> while(query.next()): >> >> idString=str(query.value(0).toString()) >> >> passwordString=str(query.value(1).toString()) >> >> >> >> query.value() returns a QVariant, so you use

Re: [PyQt] returning SQL result as ordinary python string?

2012-05-03 Thread Andrew Suffield
On Thu, May 03, 2012 at 08:15:26AM -0400, Mark Mordeca wrote: > while(query.next()): > > idString=str(query.value(0).toString()) > > passwordString=str(query.value(1).toString()) > > > > query.value() returns a QVariant, so you use .toString() to convert it to > a QString, then use

Re: [PyQt] returning SQL result as ordinary python string?

2012-05-03 Thread Mark Mordeca
:* pyqt-boun...@riverbankcomputing.com [mailto: pyqt-boun...@riverbankcomputing.com] *On Behalf Of *Panupat Chongstitwattana *Sent:* May-03-12 1:14 AM *To:* PyQt@riverbankcomputing.com *Subject:* [PyQt] returning SQL result as ordinary python string? Most example I was able to find were putting sql

[PyQt] returning SQL result as ordinary python string?

2012-05-02 Thread Panupat Chongstitwattana
Most example I was able to find were putting sql data into PyQt list/table widgets. But I wasn't able to find example to do basic query. Can anyone help give me some basic please? For example, if I query selecting from a table with 3 records query = QtSql.QSqlQuery(db) query.exec_("SELECT id,