- Zope - Zope lists

Space in column name with ZODBC
by Loren Stafford 06 Jul '01

06 Jul '01

I'm trying to create an ODBC interface to an existing (MSAccess) database that has spaces in its column names. My ZSQL looks like this... select * from "Applicant Database" <dtml-sqlgroup where> <dtml-sqltest LastName op=like column="Last Name" type=string> <dtml-and> <dtml-sqltest FirstName op=like column="First Name" type=string> </dtml-sqlgroup> ...but it generates this error... File D:\Intranet\Zope224\lib\python\Products\ZODBCDA\db.py, line 198, in query sql.error: ('37000', -3100, "[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(Last Name like 'A'\012 and First Name like ''\012)'.") There's a lot of garbage in that generated SQL, but at least I'd expect to see the column names quoted or something. Is there a trick to it? Or am I trying to do something impossible? Or is there a bug in ZODBC? -- Thanks -- Loren

3 3

NameError problem with sequence-number
by Kevin L 06 Jul '01

06 Jul '01

Hello, I can run the following code which runs fine: <dtml-in "_.range(0,5)"> <dtml-var sequence-number> </dtml-in> However adding quotes around sequence-number always gives me an error "Error Type: NameError Error Value: sequence". <dtml-in "_.range(0,5)"> <dtml-var "sequence-number"> </dtml-in> I need to use sequence-number inside of a python expression. Can anyone explain how to do this? thanks -Kevin __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/

5 5

Problem redirecting from standard_error_message
by Peter Hernberg 06 Jul '01

06 Jul '01

Having moved our website to zope, there are a number of pages that have different URLs now. I've written a little script that checks the urls returns the new url if the page has moved. Then I edited standard_error_message as follows: <dtml-let new_path="temp.translate(REQUEST['URL'])"> <--- returns the new url <dtml-if "error_type=='NotFound' and new_path"> <dtml-call "RESPONSE.setStatus('MovedPermanently')"> <dtml-call "RESPONSE.setHeader('Location', new_path)"> <--- As per rfc, this tells the client where the page has moved to <html> <body> This page has moved <a href="<dtml-var new_path>">here</a>. </body> </html> <dtml-else> ...normal standard_error_message... </dtml-if> </dtml-let> This doesn't work. The Location gets set, but the status is still 404 (which means the browsers won't automatically be redirected to the new page). This code works in a regular dtml method, but standard_error_message seems to be doing some magic which prevents the call to RESPONSE.setStatus() from working. Is there a way around this? Is there a better way to do this? Or did I miss something obvious (again:)? ===== Peter Hernberg According to Securityportal.com, I'm an "ironic and humorous... security expert." Ain't it cool? http://www.securityportal.com/articles/ramen20010119.printerfriendly.html "You must pass this message on in the next 72 hours or you will have bad luck. This mantra will come true even if you aren't superstitious!!!!" --from a forwarded email __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/

2 1

DTML_TREE loaded from a database.
by Rubinstein Fredrik 06 Jul '01

06 Jul '01

Hi there, I have an dtml-tree that is loaded from a database table. >From the table I get keyvalues and what method to be called. I try something like this. <dtml-let object_nkl="0"> <dtml-tree id=object_nkl branches_expr="hierarki_search(parent_nkl=object_nkl)"> <a href=?object_nkl= TARGET="Right"><dtml-var name></a> </dtml-tree> However when I look at this in the browser the part with the "object_nkl" is lost. Is there someone out there with some tips ? Cheers Fred.

2 1

How to set default roles to 'View management screens' permission
by Dirksen 06 Jul '01

06 Jul '01

Hi, I want to set some default roles so that they can view the management screen of my object. How to do that? Cheers Dirksen __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/

2 1

simple question! connection string... err...
by Hugo Ramos 06 Jul '01

06 Jul '01

Yellow ppl, simple question: what's the fucking connection string syntax for a foxpro database? :-) regards ===== Hugo Ramos - hugo(a)zopers.org ZopersORG - http://zopers.org/ ===== Do not meddle in the affairs of programmers, for they are easy to annoy, and have all the source code!!!

1 0

Adding an external method
by Gitte Wange 06 Jul '01

06 Jul '01

Hello, I am trying to add an external metod (used in a CMF Calendar example) but it fails. Now I'm not into these external methods (and I am not sure it's the best solution) but I just want to see how this example works. The method file is named monthRange.py and I have placed it in /usr/local/Zope/Extensions it contains this code: from DateTime import DateTime def monthRange( dt ): """ Return a pair of DateTime values representing the earliest and latest times in the month in which 'dt' falls. """ y, m, d = dt.year(), dt.month(), dt.day() first = DateTime( y, m, 1 ) last = first - 1 + DateTime._month_len[dt.isLeapYear() ][ m ] return first.earliestTime(), last.latestTime() I have filled in these values in the add form in ZMI: Id: monthRange Module Name: monthRange Function Name: monthRange I get this error when I try to add it: Error Type: SyntaxError Error Value: invalid syntax And this traceback: Traceback (innermost last): File /usr/local/Zope-2.3.2-linux2-x86/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /usr/local/Zope-2.3.2-linux2-x86/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/Zope-2.3.2-linux2-x86/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook File /usr/local/Zope-2.3.2-linux2-x86/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/Zope-2.3.2-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_addExternalMethod) File /usr/local/Zope-2.3.2-linux2-x86/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_addExternalMethod) File /usr/local/Zope-2.3.2-linux2-x86/lib/python/Products/ExternalMethod/ExternalMethod.py, line 131, in manage_addExternalMethod File /usr/local/Zope-2.3.2-linux2-x86/lib/python/Products/ExternalMethod/ExternalMethod.py, line 179, in __init__ (Object: monthRange) File /usr/local/Zope-2.3.2-linux2-x86/lib/python/Products/ExternalMethod/ExternalMethod.py, line 202, in manage_edit (Object: monthRange) File /usr/local/Zope-2.3.2-linux2-x86/lib/python/Products/ExternalMethod/ExternalMethod.py, line 209, in getFunction (Object: monthRange) File /usr/local/Zope-2.3.2-linux2-x86/lib/python/App/Extensions.py, line 217, in getObject (Info: ('/usr/local/Zope-2.3.2-linux2-x86/Extensions/monthRange.py', 'monthRange')) SyntaxError: (see above) Well it looks like it finds the file. To me it looks like there is a syntax error in the add of the external method. or is the syntax error in the python code ? I haven't debugged this kind of scripts before so I hope there is someone who can help me :-) Regards, -- Gitte Wange Jensen Sys Admin, Developer and a lot more MMmanager.org Aps, Denmark Phone: +45 29 72 79 72 Email: gitte(a)mmmanager.org Web: www.mmmanager.org Quote of the day: Unix is user friendly; it's just a little paticular about which users it is friendly to.

5 6

Python/DBI/ODBC/Zope
by Schmidt, Allen J. 06 Jul '01

06 Jul '01

We have a Python program that reads a URL, rips it apart and dumps the pieces into an ODBC connected database. Works fine from the command line. If we try to add this into Zope as an External Method, it states it cannot find the dbi component. import dbi uses a dbi.dll in Windows. This was developed on 2.1 Python but the dbi module exists in Zopes 1.52 Python so I am not sure where the problem is. Thanks Allen

2 1

Migrating to Zope2.3.3
by Priya Ramkumar 06 Jul '01

06 Jul '01

Hi I have installed Zope2.3.3 & ZEO1.0. I would now like to move the Data.fs in my old Zope installation(2.2.4) , which has CMF0 0.10alpha, to the new Zope installation. Earlier, I had copied the Data.fs, Data.fs.lock, Data.fs.tmp & Data.fs.old to the "var" directory in "Instance_home" of the new installation. But it resulted in a datacorruption error. So I have redone the Installation & would be thankful if anyone could please tell me the process of migrating the Database to Zope2.3.3. I have custom_zodb.py, zope.conf & zctl.py in my "Instance_home " directory & the ZEO in "lib/python" under "Zope_software_home". Thanks for any help. Priya.

1 0

Help with iterating thru a list of objects
by Dario Lopez-Kästen 06 Jul '01

06 Jul '01

Hello! I need to display the results of an sql query and I need to compare the value of field A in the current item with the value of field A in the previous item, in order to display things correctly. Doing this in a Python script seems overkill, since I only need to control the display of things. I have crancked upp a lot of info in the result of the query for optimization reasons so changing the query is out of the question. Any help is appreciated. Thank you, /dario - -------------------------------------------------------------------- Dario Lopez-Kästen Systems Developer Chalmers Univ. of Technology dario(a)ita.chalmers.se ICQ will yield no hits IT Systems & Services

3 3