[ Tim -- Email to you bounces--might want to check your address. ] Not seeing the problem. Here's a small test case to make sure this isn't a version difference between us. Can you see if this works? # In psql: CREATE TABLE datetest(id SERIAL PRIMARY KEY, thedate timestamp); [using date rather than timestamp works fine, too] INSERT INTO datetest (thedate) VALUES ('2001-04-01'); # ZSQL Statement "select" # no arguments or parameters SELECT id, thedate FROM datetest # Pyscript "pyscript" # one parameter: "thedate" m = thedate.Month() return "%s is the cruellest month" % m # dtml method "dtml" <dtml-var standard_html_header> <dtml-in select> <dtml-var "pyscript(thedate)"> </dtml-in> <dtml-var standard_html_footer> View "dtml" and I get "April is the cruellest month" If this works, can you send me a .zexp of your ZSQLMethod, Python Script, and DTML Method, plus SQL DDL to create a table like yours? Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton Knowledge Management & Technology Consultant
-----Original Message----- From: thawes@ncmail.net [mailto:thawes@ncmail.net]On Behalf Of Tim Hawes Sent: Tuesday, March 12, 2002 9:11 AM To: Joel Burton; zope@zope.org Subject: Re: [Zope] Datefields
Joel Burton wrote:
On Mon, 11 Mar 2002, Tim Hawes wrote:
ZPsycoPG returns datefields from postgress in yyyy/mm/dd format, while postgres' default is yyyy-mm-dd. I need to pass a date to python script for comparison w/ other datefields, but Zope apparently will not allow values to be passed with '/'s in them. Can I change the way ZPsycoPG is returning the date fields in the database? How?
Zope has no problem with passing a string like "2001/01/01" to a Python Script. Why do you think that Zope will apparently not allow values to be passed with "/" in them?
Zope Error
Zope has encountered an error while publishing this resource.
Error Type: TypeError Error Value: unsupported operand type(s) for /
Traceback (innermost last): File /usr/local/zope/2.5.0/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/zope/2.5.0/lib/python/ZPublisher/Publish.py, line 114, in publish File /usr/local/zope/2.5.0/lib/python/Zope/__init__.py, line 158, in zpublisher_exception_hook (Object: Projects) File /usr/local/zope/2.5.0/lib/python/ZPublisher/Publish.py, line 98, in publish File /usr/local/zope/2.5.0/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: ChangeProject) File /usr/local/zope/2.5.0/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: ChangeProject) File /usr/local/zope/2.5.0/lib/python/OFS/DTMLMethod.py, line 127, in __call__ (Object: ChangeProject) File /usr/local/zope/2.5.0/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ (Object: ChangeProject) File /usr/local/zope/2.5.0/lib/python/DocumentTemplate/DT_In.py, line 695, in renderwob (Object: ProjectsUpdateResultMethod) File /usr/local/zope/2.5.0/lib/python/DocumentTemplate/DT_Util.py, line 159, in eval (Object: compare_datefield('start_',proj_start)) (Info: compare_datefield) File <string>, line 2, in f File /usr/local/zope/2.5.0/lib/python/Shared/DC/Scripts/Bindings.py, line 252, in __call__ (Object: compare_datefield) File /usr/local/zope/2.5.0/lib/python/Shared/DC/Scripts/Bindings.py, line 283, in _bindAndExec (Object: compare_datefield) File /usr/local/zope/2.5.0/lib/python/Products/PythonScripts/PythonScri pt.py, line 291, in _exec (Object: compare_datefield) (Info: ({'script': <PythonScript instance at 1235610>, 'context': <r instance at 1383f28>, 'container': <Application instance at dd8220>, 'traverse_subpath': []}, ('start_', DateTime('2002/02/25')), {}, None)) File Script (Python), line 50, in compare_datefield File Script (Python), line 12, in cdate File /usr/local/zope/2.5.0/lib/python/DateTime/DateTime.py, line 668, in __init__ File /usr/local/zope/2.5.0/lib/python/DateTime/DateTime.py, line 276, in _calcSD TypeError: (see above)
When I try to put this value in when I test the python script 'compare_date', it has no problems. I pass the value in dtml, I get this error. This is what has led me to believe that the problem is in how Zope handles it.
Now, looking at it, perhaps the problem is in how I am calling it in dtml? Here is the dtml code that I use inside a database query sequence: <dtml-var expr="compare_datefield('start_',proj_start)"> The first parameter is for an input tag variable name that is prepended to the default, the second (proj_start) is a dtml var containing a datefield for the script to compare. The end result is html code containing individual selection boxes for day, month and year, w/ the default selection at what is already in the database. I have another version of this script working that compares the DateTime() value with all date ranges to produce defaults for the current day, month, and year, and compare_date() does the same thing except that it creates a new DateTime() object from the second parameter that is passed to it.