Advertisement
Guest User

Untitled

a guest
Jan 30th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. import firebirdsql
  2.  
  3. # connessione database
  4. conn = firebirdsql.connect(
  5. host='localhost',
  6. database='/leadmanager/leadmanager.gdb',
  7. port=3050,
  8. user='****',
  9. password='****'
  10. )
  11.  
  12. cursor = conn.cursor()
  13.  
  14. datins = "'10/10/18'"
  15.  
  16. cursor.execute("select id,nome,cognome,datins,idxesito,idxchiusura,usomarca,usomodello from lead where datins > " + datins)
  17.  
  18. for c in cursor.fetchall():
  19. print(c)
  20.  
  21. # chiusura connessione
  22. conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement