ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> db-sig
db-sig
[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	
*************************************************

Privacy Policy | Email Opt-out | Feedback | Syndication
© ActiveState Software Inc. All rights reserved