¡@
python Programming Glossary: result_setHow to retrieve SQL result column value using column name in Python? http://stackoverflow.com/questions/10195139/how-to-retrieve-sql-result-column-value-using-column-name-in-python cursor.execute SELECT name category FROM animal result_set cursor.fetchall for row in result_set print s s row name row.. category FROM animal result_set cursor.fetchall for row in result_set print s s row name row category edit According to user1305650..
Parameter substitution for a SQLite “IN” clause http://stackoverflow.com/questions/1309989/parameter-substitution-for-a-sqlite-in-clause INTO distro name VALUES ' name desired_ids 1 2 5 47 result_set c.execute 'SELECT FROM distro WHERE id IN s ' .join desired_ids.. distro WHERE id IN s ' .join desired_ids for result in result_set print result It prints out 1 u'Ubuntu' 2 u'Fedora' 5 u'SuSE'.. I am hoping to use parameter substitution. When I try result_set c.execute 'SELECT FROM distro WHERE id IN ' .join desired_ids..
|