[DB-SIG] Python and database problems
by Tobias Höink other posts by this author
Mar 4 1999 7:43PM messages near this date
[DB-SIG] Python and database problems
|
[DB-SIG] annotated 1.1 spec / feedback
Dear "Phythons",
my name is Tobias Hoeink. I am programming for the German Society of
Physicists in Muenster, Germany. For registration we use CGI-Scripts
written in Python. We read information from HTML forms and put them into
an Access database. So far there is no problem, everything works fine.
We use two fields for dates in this Access database and this is where
something very strange happens:
While reading dates out our database the date somehow changes into the
date of the day before. As this seems to be a systematical error which
occurs somewhere between Python and ODBC we were not able to handle it.
To get in tough with our problem please look at
http://dpg-akf.uni-muenster.de/dpg/dpg_liste.html
and search e.g. for member number (Teilnehmernummer) 478. The returning
page
will show you two dates. Both are exact one day before the day saved in
our database. If you search the name "Nink" (field Nachname) an other
listing will be presented with the same effect. I asure you that the
original dates in this recordset are saved with anmeldedatum = 02/25/199
and
kartendatum = 03/25/1999.
This problem occurs on any date we read out of the database!
Please let us know what the mistake is and how we can solve the problems
that are concerned with that.
I would also be interested if we are the only ones presented to this
effect.
Thank you very much.
I hope to hear from you soon.
Sincerely Yours,
Tobias Hoeink
--
*************************************************
Tobias Höink
Heekweg 12, E408
48161 Münster
GERMANY
phone: +49-251-868852
email: hoeink@[...].de
*************************************************
|