December 2000 - Zope

string splitting in dtml
by Mike Kelland 04 Dec '00

04 Dec '00

I have a date string (ie dd/mm/yy) which I'm drawing out of a database (ODBC connection to Access) with a Z SQL method and I need to use that data to set the initial condition of a set of 3 select items (ie day, month and year). Is there a way to split this date (it'll come out looking like dd/mm/yy) to get the components of it so that I can do: <select name="start_month"> <dtml-in "1,2,3,4,5,6,7,8,9,10,11,12"> <dtml-if "some_split_of_date_string_to_get_month(start_date) == _['sequence-item']"> <option value="<dtml-var sequence-item>" selected><dtml-var sequence-item></option> <dtml-else> <option value="<dtml-var sequence-item>"><dtml-var sequence-item></option> </dtml-if> </dtml-in> </select> ?? Thanks! Mike Kelland mike(a)studiomatic.com

2 1

Software registration
by art＠asesoft.ro 04 Dec '00

04 Dec '00

Dear Sir or Madame, Our company Asesoft Com. involved in Web related services, in conjunction with Esex Gmbh. and the PromoSoft organization is developing at this moment a new software portal (http://www.eRomania-net.com/, www.eRomania-net.ro) which we intend to be from the beginning one of the most important european sites in that domain, and than from the entire net. Here we are also going to provide informations from other various domains like banking, assurances, health, travels, music, electronics, computers, Internet and much more. That's why, we would like to present your applications on this site, in our software section, so anyone could see a detailed description of your product and download a trial version. If you are interested, please visit our software submission page at http://www.eRomania-net.com/software/adsoft.php, where all you have to do is to complete a form with a detailed description of your software, your license agreement and any other terms that you require, the category where it should be included, a link to your order or contact page and a direct link to your shareware or freeware product. Please feel free to contact us with any additional questions or suggestions regarding our new site. Thank-you in advance for your participation. With best regards, Arthur Radulescu, Project Manager Email: art(a)asesoft.ro Mobile phone: (040) 93 620 084 Web site: http://www.asesoft.ro

1 0

Problem with DCOracle interface for Python
by Spicklemire, Jerry 04 Dec '00

04 Dec '00

Slim Says: > I am having a problem when I try to run a python application on a Sun server: We had some problems like this too. If memory serves, an incompatibility between older versions (Oracle 7.x) of the Oracle Networking package, and the new version (Oracle 8) of the database "backend" was the cause. The new (Net8) code can talk to older RDBM engines, but the old code can't talk to Oracle 8. Good Luck, Jerry S.

1 0

Passing lists in a get request (ZCatalog Search) Continued...
by Darin Lee 04 Dec '00

04 Dec '00

Zopistas, Everyone, Thanks for the help so far. My searchable form and indexes are working great, except for one small problem. Whenever I pass in a string to search on a text-index, along with the sort_on and/or sort_order parameters I keep getting the following error: Error Type: TypeError Error Value: loop over non-sequence Traceback (innermost last): File C:\PROGRA~1\DEQ_UP~1\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\PROGRA~1\DEQ_UP~1\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\PROGRA~1\DEQ_UP~1\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File C:\PROGRA~1\DEQ_UP~1\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\PROGRA~1\DEQ_UP~1\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: search) File C:\PROGRA~1\DEQ_UP~1\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: search) File C:\PROGRA~1\DEQ_UP~1\lib\python\OFS\DTMLMethod.py, line 172, in __call__ (Object: search) File C:\PROGRA~1\DEQ_UP~1\lib\python\DocumentTemplate\DT_String.py, line 528, in __call__ (Object: search) File C:\PROGRA~1\DEQ_UP~1\lib\python\DocumentTemplate\DT_In.py, line 473, in renderwb (Object: Catalog) File C:\PROGRA~1\DEQ_UP~1\lib\python\Products\ZCatalog\ZCatalog.py, line 455, in searchResults (Object: Traversable) File C:\PROGRA~1\DEQ_UP~1\lib\python\Products\ZCatalog\Catalog.py, line 602, in searchResults File C:\PROGRA~1\DEQ_UP~1\lib\python\Products\ZCatalog\Catalog.py, line 555, in _indexedSearch TypeError: (see above) So, on a hunch - I tried the query directly on the Catalog method itself (not my home-brew code). I typed in "http://myserver/Catalog/report?main_references=Air&sort_on=category&sort_or…" Same problem - I f I try to query against a zCatalog text-index, and also pass the sort_on or sort_order parameters - I get the error. Is this a Zope bug? I'd appreciate any information anyone can pass on - I'm so close to getting this thing working... Thanks in advance, -Darin Lee

1 0

News article.
by J. Michael Mc Kay 04 Dec '00

04 Dec '00

If anyone has a copy of a recent news article in the Fredericksburg Free Lance Star about DC, would they please send me a copy to hisnibs(a)virginiaweb.com. Thanks...

2 1

Problem with DCOracle interface for Python
by Slim_Bouzguenda＠amsinc.com 04 Dec '00

04 Dec '00

To who it may concern: I am having a problem when I try to run a python application on a Sun server: it crashes when it interfaces with the oracle database. The error message that I got after debugging is the following: /usr/local/lib/python1.5/DCOracle/ociCurs.py(269)execute( ) Here are the versions of the program, file, and the Oracle server that I am using: - python version 1.5 - ociCurs version 1.8 - Oracle8.1.6 server Note: I tried to run the same python application to do the same task in HP server, and I did NOT have any problem; the interface with the database went fine, and the application rans smoothly. I am not sure why it did crash on the Sun server, but it did not on HP server. The versions of the file, programs, and the Oracle server are the same for both HP and Sun. It would be great if someone could give me some suggestions or hints to solve the problem. I would appreciate that. I can be reached at (303) 215-7872 or by e-mail. Best regards, Slim Bouzguenda E-mail: Slim_Bouzguenda(a)ams.com Office: (303) 215-7872

2 1

Re: [Zope] where (required)
by Dieter Maurer 04 Dec '00

04 Dec '00

Tom Deprez writes: > ... optional tests and optional paramters in Z SQL methods ... The "where" of "dtml-group" will generate a "where" keyword, if the enclosed query is not empty. However, you must pass the declared parameters whether or not you use them. You can provide default values, though. The syntax is parameter="" to give "parameter" the empty string as default value. Dieter

1 0

Re: [Zope] The inverse of REQUEST.set is ??
by Dieter Maurer 04 Dec '00

04 Dec '00

Dennis Nichols writes: > ... deleting an item from request ... DTML will not let you do that. In Python, you can use "del REQUEST.other['something']" Dieter

1 0

Re: [Zope] ZSQLMethods
by Dieter Maurer 04 Dec '00

04 Dec '00

Tom Deprez writes: > I'm wondering how the following can be done. > > I've 2 databases. I want to do a 'join' with 2 tables, both in a different > database. > Is it possible to retrieve data of both tables with a ZSQLMethod and then > do a programatically join? What's the easiest python way? Search the (seachable) list archive. There was recently a thread about getting data from two ODBC data sources and joining the results. Dieter

1 0

Re: [Zope] Accessing hierarchical information in a CORBA server
by Dieter Maurer 04 Dec '00

04 Dec '00

vonWedel(a)lfpt.rwth-aachen.de writes: > Dies ist eine mehrteilige Nachricht im MIME-Format. > --=_alternative 0034F414C12569AB_= > Content-Type: text/plain; charset="us-ascii" Can you avoid to send MIME messages into this list? > ... tree for hierarchical data on CORBA server ... > ... from (http://www.zope.org/Members/anthony/tree-coding-tricks: > class _dummy: > def __init__(self, name): > self.name=name > > def child_lookup(parent): > c = [] > for i in range(0,5): > c.append(_dummy("%s.%d"%(parent, i))) > return c > > used like this: > > <dtml-let name="0"> > <dtml-tree id=name branches_expr="child_lookup(parent=name)"> > <b><dtml-var name></b> > </dtml-tree> > </dtml-let> > > .... > The tree can obviously only handle > functions, not real CORBA > objects The tree can (and does) handle objects. The expression "branches_expr" is evaluated in the context of the current objects. As Python is dynamically typed, the objects can have different types. The only restriction: "branches_expr" must be evaluable in each context. > CORBA objects are identified by a so-called IOR which is some sort of a > stringified object reference > but in a non-readable way. Can I use a non-unique 'display name' for each > node in the tree and > some unique identfier (the IOR) internally? Of cause, the "display names" must be locally unique (i.e. in their parent). They need not be globally unique. > Sorry for so many questions, but I haven't found a lot of info about using > the dtml-tree together with > external methods. I saw two questions. That's not a lot. Dieter

1 0