Advertisement
Guest User

Untitled

a guest
Apr 21st, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. parsed_string = json.loads(json_string)
  2. cursor.execute("update Table set Status = ? where Name like ? ",(json.dumps(parsed_string), "Blabla"))
  3. cnxn.commit()
  4.  
  5. cursor.execute("""select Status from Table where Name like ?""", "Blabla")
  6. cursor.fetchall()
  7.  
  8. "{"orderID": 42, "orderContents": [{"productName": "keyboard", "quantity": 1, "productID": 23}, {"productName": "mouse", "quantity": 1, "productID": 13}],
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement