lundi 12 octobre 2015

How can I insert array elements into SQLite table by index?

Seems like array element index isn't a type that SQLite INSERT will allow.

contact[0] = raw_input("Last Name: ")
contact[1] = raw_input("First Name: ")
contact[2] = raw_input("Street Address: ")
contact[3] = raw_input("City: ")
contact[4] = raw_input("State: ")
contact[5] = raw_input("Zip Code: ")
contact[6] = raw_input("Phone: ")
contact[7] = raw_input("Email: ")

cur.execute("INSERT INTO Contacts VALUES(contact[0], contact[1], contact[2], contact[3], contact[4], contact[5], contact[6], contact[7])")

Is there a way to do this? Thanks!

Aucun commentaire:

Enregistrer un commentaire