What different QSqlQuery in Qt and PyQt ?
query.prepare("select id, nama, id_group, groups from pemakai where nick=:a and groups=:b")
query.bindValue(":a", self._username)
query.bindValue(":b", self._grp)
if query.exec_():
print "OK"
else:
print query.lastError().text()
query=QSqlQuery()
query.prepare("select id, nama, id_group, groups from pemakai where nick=:a and groups=:b")
query.bindValue(":a", self._username)
query.bindValue(":b", self._grp)
if query.exec_():
print "OK"
else:
print query.lastError().text()
To copy to clipboard, switch view to plain text mode
Result:
ERROR: wrong number of parameters for prepared statement "qpsqlpstmt_1"
DETAIL: Expected 2 parameters but got 0.
QPSQL: Unable to create query
Bookmarks