Re: "getObjProperty" in connection with Postgres

Hello,
thanks for your hints: the displayCalender is under progress - step by step ..

After install the latest patch from
ZMS: ZMS2 2.11.41
to
ZMS: ZMS2 2.12.1-12 (Build #132e)
ZOPE: (Zope 2.10.9-final, python 2.4.3, linux2)
PYTHON: 2.4.3 (#1, Jun 11 2009, 14:09:58) [GCC 4.1.2 20080704 (Red Hat 4.1.2-44)]

we have problems with the data-input in our calendar/:
[1]
Edit in ZMS a new data I got the following error:

... "/usr/lib/zope/lib/python/DocumentTemplate/DT_Util.py", line 196, in eval return eval(code, d) File "", line 0, in ? File "/usr/lib/zope/lib/python/Products/zms/zmssqldb.py", line 934, in recordSet_Insert sqlStatement.append( ' AND '.join(map( lambda x: x['id']+'='+x['value'], filter( lambda x: x['value'].upper()!='NULL', c)))) File "/usr/lib/zope/lib/python/Products/zms/zmssqldb.py", line 934, in  sqlStatement.append( ' AND '.join(map( lambda x: x['id']+'='+x['value'], filter( lambda x: x['value'].upper()!='NULL', c)))) AttributeError: 'NoneType' object has no attribute 'upper' (02.02.10 20:39:17) 

Nevertheless the data is recorded in the DB and I can work with it.

[2]
The Configuration in the SQL-Database doesn't work: Parallel to the Folie 11 of the Charts_fh_ZMSSQLDB.pdf I have no opportunity to add anything

[3]
I guess therefore the construction doesn't work correct: The order of the records in the interface is not like this in the sqlmodel.

Any hints for me?
Best Regards
Astrid

--- In [email protected], "Dr. Frank Hoffmann" <fh@...> wrote:
>
> Hello,
> 1. getObjProperty() gets language conformant an attribute value of a _ZMS_
> object
> 2. usually you iterate through a database object an get a field name by
> using it's name as a variable - without any function call.
> 
> Hint-1:
> If you have to rebuild a complex presentation layer like a calendar, it
> might be efficient to recycle most of the existing code by adding a ZMSSQLDB
> Object to the calender and modify the template vars/objects on which you are
> iterating. These objects might a generated by a ZSQL method.
> 
> Hint-2:
> Here the ZMS concept of automatic GUI generation is explained
> http://www.zms-publishing.com/news/06_09_sql_db/
> Here you will find all about Relational Database Connectivity
> http://docs.zope.org/zope2/zope2book/RelationalDatabases.html
> 
> Good luck
> fh, moderator
>