I think the whole idea of timestamps is that they're system generated. Use DATE/TIME fields instead and convert the timestamp value to do the comparison.
-----Original Message----- From: Stephan Stapel [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 March 2003 2:32 a.m. To: [EMAIL PROTECTED] Subject: Questions on the Python interface Dear list, I've got some question on the python interface of sapDB, I hope that someone is able to help.... If I insert a row into a table like: C = sapdb.connect(............) query = "INSERT INTO maildata (data) VALUES ('%s')" % msg['Header'] result = C.sql(query) how to I retrieve the primary key of the table (an int serial(1)). This: "header_id = result.getLastSerial()" doesn't unfortunately work (as was suggested on the different sapDB dedicated sites) Also, how to I easily convert arbitrary date/time values into a sapDB timestamp? Are there any utility functions for that? I have something like 2003-03-18 11:24 (from an email header). Thanks in advance an Kind regards, Stephan _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
