[Modeling-users] Strange date conversion in fetch qualifier

[<luk...@po...>]

Hi

I've got some problem with conditions that using dates. The following
examlple shows this.

ERD:
       MaWychowawce
Klasa|<<--------------->|Nauczyciel
-----|                  |------------
                        |attr: DataUrodzenia

code:
---------------------------------------------------------------------
warunek=3D'MaWychowawce.DataUrodzenia > '+str(DateTime(1970,1,1))
print warunek
klasy=3DEC.fetch('Klasa',qualifier=3Dwarunek)
---------------------------------------------------------------------

Printed qualifier look like this: MaWychowawce.DataUrodzenia > 1970-01-01
00:00:00.00
I've tried with: MaWychowawce.DataUrodzenia > '1970-01-01 00:00:00.00' bu=
t
it also didn't work
Conditions on another attributes in 'Nauczyciel' works perfectly.

error
---------------------------------------
Couldn't evaluate expression SELECT DISTINCT t0.KLASA_ID, t0.NAZWA,
t0.PROFIL, t0.WYCHOWAWCA_ID FROM KLASA t0 INNER JOIN NAUCZYCIEL t1 ON
t0.WYCHOWAWCA_ID=3Dt1.NAUCZYCIEL_ID WHERE t1.DATA_URODZENIA > '1970'. Rea=
son:
libpq.OperationalError:ERROR: bad timestamp external representation '1970=
'

Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "Baza.py", line 45, in PobierzDane
    klasy=3DEC.fetch('Klasa',qualifier=3Dwarunek)
  File "C:\PROGRA~1\Zope2.6.2\bin\Modeling\EditingContext.py", line 1419,=
 in
fetch
    return self.objectsWithFetchSpecification(fs)
  File "C:\PROGRA~1\Zope2.6.2\bin\Modeling\EditingContext.py", line 1302,=
 in
objectsWithFetchSpecification
    objects=3Dself.parentObjectStore().objectsWithFetchSpecification(fs, =
ec)
  File "C:\PROGRA~1\Zope2.6.2\bin\Modeling\ObjectStoreCoordinator.py", li=
ne
434, in objectsWithFetchSpecification
    return store.objectsWithFetchSpecification(aFetchSpecification,
anEditingContext)
  File "C:\PROGRA~1\Zope2.6.2\bin\Modeling\DatabaseContext.py", line 1817=
,
in objectsWithFetchSpecification
    anEditingContext)
  File "C:\PROGRA~1\Zope2.6.2\bin\Modeling\DatabaseChannel.py", line 394,=
 in
selectObjectsWithFetchSpecification
    entity)
  File
"C:\PROGRA~1\Zope2.6.2\bin\Modeling\DatabaseAdaptors\AbstractDBAPI2Adapto=
rLa
yer\AbstractDBAPI2AdaptorChannel.py", line 297, in selectAttributes
    raise GeneralAdaptorException, msg
Modeling.Adaptor.GeneralAdaptorException: Couldn't evaluate expression
SELECT DISTINCT t0.KLASA_ID, t0.NAZWA, t0.PROFIL, t0.WYCHOWAWCA_ID FROM
KLASA t0 INNER JO
IN NAUCZYCIEL t1 ON t0.WYCHOWAWCA_ID=3Dt1.NAUCZYCIEL_ID WHERE
t1.DATA_URODZENIA > '1970'. Reason: libpq.OperationalError:ERROR:  Bad
timestamp external representation '1970'
------------------------------------

Is there any explanation?


****************************
* =A3ukasz =A3akomy
* luk...@po...
****************************