- Zope - Zope lists

ZMySQLDA and Win32 Zope crash
by peter bengtson 17 Jan '01

17 Jan '01

Phil and rest of the Zommunity I followed the instructions on http://www.zope.org/Members/philh/mysql which has helped me successfully twice (out of two before) on Windows NT and Windows 2000. This installation was seemless like others, and the product doesn't look broken from the Control_Panel/Products view. The only thing I've been able to do (not too bad) is to add a Z MySQL Database Connection with the proper syntax there "database root <password>". That works fine. Whenever I try to use the connection in any way, it crashes Zope! "An application error has occurred and an application error log is being generated. python.exe" ... and from the console Zope (in debug mode) looks to be still running, but from the management interface I can see that it's not (nothing happens!). William Crandall had a similar question with more details but with the same result as I. No answer to this one: http://zope.nipltd.com/public/lists/zope-archive.nsf/242bb7cc2b2c343d802568a b003585d4/f5a855d999e73c978025693600507b4e?OpenDocument I tried it on 2.2.2, failed tried to upgrade to 2.2.5 failed as well. MySQL: 3.22.34-shareware-debug (no anonymous user set up) Windows NT(4) Python 1.5.2 in Program Files but I have that other python.exe in the <zope dir>/bin ZMySQLDA 1.1.3 I used the MySQL.pyd you provided from your How-To I also used the libmySQL.dll you provided from your How-To What can be the reason for this? Is it strange Zope/ZMySQLDA behaviour or is it my MySQL? Thanks alot!, Peter

2 1

RE: [Zope] Zope Versus Enhydra Comparison article
by Max Møller Rasmussen 17 Jan '01

17 Jan '01

From: Ron Bickers [mailto:rbickers@logicetc.com] >> Using Zope we knew that we would reach situations which may be >> unresolvable in the short term, and could not make significant business >> decisions with so many unknown factors and lack of any way to circumvent >> problems. >What in the world does that mean?!? Maybe it should read "We don't know how >to use Zope or code in Python." No it probably means that in enhydra they can solve any problem with brute force, just like you can in asp and php. Ie. if you have trouble understanding the security mechanism in Zope you are lost until you understand it. If you have trouble with the Enhydra security mechanism, you can allways write your own. Sometimes you can get stuck in Zope for days, without knowing how to proceed, or without knowing how to find out, because you simply got to do it the Zope way. In a commercial setting that is very dangerous when you work on a deadline. In a simpler system you have to do more yourself, but you won't be painted into a corner as easily, as you can allways do a "hack". to solve your problem. Zope is more closed in that regard. Well anyways when you know enough about Zope to make a hack, you probably also know how to do it the right way. But it's only a matter of documentation AFAIK. Regards Max M

3 2

verify whether html <input type=file... is empty
by Andrei Belitski 17 Jan '01

17 Jan '01

Hi! Don't know if it is really a zope question, but I have a problem, verifying if e.g. input <INPUT TYPE="file" NAME="image_1" SIZE="50"> is empty or not using <dtml-unless " REQUEST[ 'image_1']=='' "> <dtml-call "manage_addImage( id=imageId, file=REQUEST[ image_1], REQUEST=REQUEST )"> </dtml-unless> well, I think the <input type=file... is not a string, but what I want to test is if the user put in the filename and not whether the really existing file is empty, so how could aI do it? I would appreciate any hints Thank you in advance Andrey

2 1

RE: [Zope] verify whether html <input type=file... is empty
by James Sintz 17 Jan '01

17 Jan '01

Andrey, One way would be to simply test for it on your form action page. <dtml-if "image_1 == ''"> <p>Sorry! You need to include an image.</p> <dtml-else> <dtml-call "manage_addImage( id=imageId, file=REQUEST[ image_1], REQUEST=REQUEST )"> </dtml-if> Jamey > -----Original Message----- > From: Andrei Belitski [SMTP:andrei.belitski@student.uni-tuebingen.de] > Sent: Wednesday, January 17, 2001 9:16 AM > To: zope(a)zope.org > Subject: [Zope] verify whether html <input type=file... is empty > > Hi! > Don't know if it is really a zope question, but I have a problem, > verifying if e.g. input > <INPUT TYPE="file" NAME="image_1" SIZE="50"> > is empty or not using > <dtml-unless " REQUEST[ 'image_1']=='' "> > <dtml-call "manage_addImage( id=imageId, file=REQUEST[ image_1], > REQUEST=REQUEST )"> > </dtml-unless> > well, I think the <input type=file... is not a string, but what I want > to test is if the user put in the filename and not whether the really > existing file is empty, so how could aI do it? > > I would appreciate any hints > Thank you in advance > Andrey > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

case-insensitive searches
by Maggie Shapland 17 Jan '01

17 Jan '01

I wrote: >How does one do a case-insensitive search using sql >methods when the underlying database is case-sensitive? Although I can >force the search on the database to look for a lower case string, I >cant make the person giving the value give me the value in lower case, >and I know I shouldnt use dtml-var due to security reasons. >I guess I really want the dtml-var attributes implemented >in sql-var since >lower(fieldname) like <sql-var "'%' + fieldname + '%'" > type=string lower> >does a case sensitive search whereas: >lower(fieldname) like '%<dtml-var fieldname lower>%' >works fine since it forces the user input to lower case I realise one can force the case of the input by an extra call in the report before the dtml-in clause eg <dtml-call "REQUEST.set('car', _.string.lower(REQUEST['car']))"> but it would still be nice to be able to include lower as an attribute to sqlvar. By the way I am trying to document SQL solutions (relating to Oracle) as I hit them in: http://www.cse.bris.ac.uk/~ccmjs/zope_sql.htm ---------------------- Maggie Shapland, Computing Service, University of Bristol, Tyndall Av, Bristol BS8 1UD Tel: 0117-9289869 (Int 9869) Email: Maggie.Shapland(a)bristol.ac.uk Web page: http://www.cse.bris.ac.uk/~ccmjs/ 1925 Lanchester 21, 1925 Talbot 10/23, 1929 Peugeot 190S, 1986 Moss Monaco

1 0

ZWiki --> MS Word
by peter bengtson 17 Jan '01

17 Jan '01

Searched zope.org, the z mailing list and google.com (the only search engines I use these days) I'm looking for some tool to convert ZWiki text to MS Word. Reason being that my boss wants it in MS Word, and I do all my typing as ZWiki's. Any solution is welcomed! Since ZWiki's are CaPs neurotic, some sections are called for example: "OrganiSations" or "PaGe". Also the text has these references. Bare in mind, that it doesn't have to be a native Zope or python thing, but I post it here in hope. /Peter

6 5

Stopping a <dtml-in>
by Diego Rodrigo Neufert 17 Jan '01

17 Jan '01

Hi, how can I stop a dtml-in loop? Something like: <dtml-in "_.range(1000)"> ...code... <dtml-if valueOk> STOP THE LOOP </dtml-if> </dtml-in> thanks in advance..... -- Diego Rodrigo Neufert Webmaster / Web Developer - Magic Web Design ----------------------------------------------------------- diego(a)magicwebdesign.com.br www.magicwebdesign.com.br Curitiba - PR - Brasil

2 1

slow response with 2.2.5b1, 2.2.5, 2.3.0b1 win32 version
by clamor＠fafalter.de 17 Jan '01

17 Jan '01

Hi, beginning with Zope 2.2.5b1 I noticed some latency between requests and responses (about 3 seconds) even of simple pages. This applies to the 2.2.5 and the 2.3.0b1 releases as well. It occurs only on win32 installations. The 2.2.4 release runs fine on the same machines. There was a similar post by the end of last year, but unfortunately I didn't find an "enlightening" ;-) answer on the list. Anyone else with the same phenomenon? Any suggestions? Bories ---- Bories v. dem Bussche clamor(a)fafalter.de

3 2

2Q: Catalog and REQUEST
by alan runyan 17 Jan '01

17 Jan '01

I have a calendar each day is a radio button and the name=schedule_mmddyyyy when I post to a page I want to do something like, get all the values that start with 'schedule'. I found no examples on how to iterate over the REQUEST objects values. anyone? times=[] for key in REQUEST['form'].keys(): if key[:8]=='schedule': times.append(REQUEST['form'][key]) second question: I have some searchResults() when I say <dtml-in searchResult><dtml-var sequence-item></dtml-in> (when are we going to get rid of sequence-item?) I get instance None instance instance instance but <dtml-in searchResults> <dtml-if "_['sequence-item']!=None"> <dtml-var sequence-item></dtml-if> </dtml-in> doesnt work. running on the latest beta, really nice :) ~runyaga

1 0

case insensitive searches
by Maggie Shapland 17 Jan '01

17 Jan '01

How does one do a case-insensitive search using sql methods when the underlying database is case-sensitive? Although I can force the search on the database to look for a lower case string, I cant make the person giving the value give me the value in lower case, and I know I shouldnt use dtml-var due to security reasons. I guess I really want the dtml-var attributes implemented in sql-var since lower(fieldname) like <sql-var "'%' + fieldname + '%'" type=string lower> does a case sensitive search whereas: lower(fieldname) like '%<dtml-var fieldname lower>%' works fine since it forces the user input to lower case ---------------------- Maggie Shapland, Computing Service, University of Bristol, Tyndall Av, Bristol BS8 1UD Tel: 0117-9289869 (Int 9869) Email: Maggie.Shapland(a)bristol.ac.uk Web page: http://www.cse.bris.ac.uk/~ccmjs/ 1925 Lanchester 21, 1925 Talbot 10/23, 1929 Peugeot 190S, 1986 Moss Monaco

1 0