- Zope - Zope lists

RE: [Zope] newbie - odbc missing operator
by Phillip J. Eby 16 Aug '99

16 Aug '99

At 07:03 PM 8/16/99 -0400, Rob Page wrote: > >If there are one or more areacodes in the list it will render something >like: > >SELECT stuff FROM contact >where > phone LIKE '(540)%' OR > phone LIKE '(703)%' OR > phone LIKE '(813)%' > >or at least it looks like it should! :^) > >I think this would be REALLY slow. > Depends on the backend. Sybase handles this blindingly quickly. I know because IDS' e-mail portal builds an OR list like this for every word in the subject line of an e-mail to match against a table to see if it recognizes the word as a domain name we host. The table it scans holds about 200,000 domain names, and almost 1 million records total, but the queries execute in a couple seconds, tops. The field is indexed, but it only holds 24 characters and the domain names can be longer. So on any word longer than a certain number of characters, we have to do a wildcard search. (Don't ask.) Anyway, Sybase and many other databases recognize that they can use indexes to speed queries of the form "LIKE 'xxx%'". So the above query will execute as quickly on such databases as an '=' or 'IN'-based query.

1 0

RE: [Zope] newbie - odbc missing operator
by Rob Page 16 Aug '99

16 Aug '99

> Thanks for the pointer. Let's get into some Z stuff. How does > one do the > following? > Instead of the string '(918)' we need to select for a list of > areacodes. > i.e. (918), (404), (950). > > something like ... > select name, phone from contact where phone LIKE '(918)%' OR > phone LIKE > '(404)%'.... > should be built using DTML??? > but how? Well, if it were me, I'd munge the data and get the areacode into its own field and do MUCH more efficient SQL = operators... Alternatively, assuming you had a form variable called areacodes:list <UNTESTED ZSQL Method CODE> SELECT stuff FROM contact   phone LIKE '()%'  OR    If the user doesn't select any areacodes the sqlgroup (with the optional tag) will render: SELECT stuff FROM contact If there are one or more areacodes in the list it will render something like: SELECT stuff FROM contact where phone LIKE '(540)%' OR phone LIKE '(703)%' OR phone LIKE '(813)%' or at least it looks like it should! :^) I think this would be REALLY slow. --Rob

1 0

newbie - odbc missing operator
by Michael Guidry 16 Aug '99

16 Aug '99

Using dbase, I want to find all records which have a phone that begins with a specific area code. I try select name, phone from contact1 where phone startswith '(918)' (The same query works with crystal report.) which produces... Error, sql.error: ('37000', -3100, "[Microsoft][ODBC dBase Driver] Syntax error (missing operator) in query expression 'phone1 startswith '(918)''.") I can use = as an operand but need to know how to use other odbc operands. Also, anyone know where a list of operands for dbase might be located on the internet. Michael Guidry michael.guidry(a)trigenttechnologies.com

3 3

Multi-statement ZSQL Methods
by Jeremy Fitzhardinge 16 Aug '99

16 Aug '99

Hi all, I'm using Zope with MySQL to do fairly normal database type things. A number of my tables make use of the AUTO_INCREMENT feature to generate unique primary keys, which I use internally for things like user IDs. The problem is that after inserting a user, I want to use LAST_INSERT_ID() to get it back. This is what I tried: insert users (name, email, type) values('foo', 'bar(a)biff.org', 'normal'); select user_id from users where user_id = LAST_INSERT_ID() This always complains about a syntax error at the ';'. Normally with MySQL I could issue a second requst to the the last inserted ID, but MySQL keeps that on a per-connection basis. If all Zope threads share the same database connection, what certainty do I have that another thread hasn't inserted a new user in between my insert and select? Do I need to do my own Zope-level locking? Is there a better way of dealing with this? Thanks, J

2 2

Import error
by Luciano Ramalho 16 Aug '99

16 Aug '99

During a maintenance task I had to bring back to my office a full copy of the Zope site installed in a client. I copied the Data.bbb file from the client server to the zope/var directory in a local server. After running Zope, I got the message below. What does it mean, and what should I do to avoid it? Best regards, Luciano Ramlho -- Sorry, a SERIOUS APPLICATION ERROR occurred.<p>  -- Hiperlógica <http://hiper.com.br> Automação de web-sites | Web-site automation São Paulo | Brasil | Fone: +55-11-251-4894

1 0

Documentation vs. Code
by Kevin Dangoor 16 Aug '99

16 Aug '99

IMHO, Digital Creations has gone the right route, thus far, by placing emphasis on getting the code out the door and not holding things up for the documentation. In my own self-interests, it has given me the capabilities that I *need* for the next phase of my site (and for other sites that are planned). Because of the current learning curve and somewhat hit-or-miss documentation, Zope is still in a sort of "early adopter" phase, where it takes a bit of effort, but there are rewards (namely the functionality) for those that stick with it. The main reason, however, that I think DC did the right thing is right around the corner: the Zope Portal Toolkit and the new zope.org site. I haven't seen the new site, yet. But I know the kinds of things that are possible with ZClasses and ZCatalog. (Not just possible, but pretty straightforward and quick to implement!) Not only does this make for a much more powerful tool for the early adopters, but it also will create a much better collaboration environment at zope.org. I have no doubts that people will come up with great ideas on the how the community can collectively improve the documentation and make far more information readily available. (And, it will all be readily searchable, thanks to ZCatalog). All of the work that has been leading up to the ZPT has probably slowed the creation of documentation... but the ZPT itself is a tool that can help correct the problem. Kevin

1 0

Fwd: Re: Python CGI Scripts (Re: [Zope] Giving up in frustration)
by Patrick Phalen 16 Aug '99

16 Aug '99

>From today's Python List: ---------- Forwarded Message ---------- Subject: Re: Python CGI Scripts Date: Mon, 16 Aug 1999 20:24:42 +0000 (UTC) From: Jonathon <jblake(a)stamp-coin.com> On Mon, 16 Aug 1999, Rudi Angela wrote: >Yep, have a look at Zope, a python based opensource cgi solution: From my POV, Zope has two major problems. #1: It expects to run as a server. This is not a good thing, from the POV of most IPPs and ISPs. #2: The documentation is somewhat lacking. << This one is easy to fix. >>

2 1

RE: [Zope] Giving up in frustration
by Paul Everitt 16 Aug '99

16 Aug '99

Patrick wrote: > Hadar wrote: > > I am very sorry to see you go. We all understand and feel > > for your frustration. We hate to lose even a single person > > because of a stupid reason like this, but alas, it is a > > chicken and egg problem. We are building a large and complex > > system, all at our own risk. We give it away, and support > > the hell out of it, and yes, documentation lags (sometimes > > too much). > > Hadar, > > I'm afraid I simply can't *afford* to sympathize with your > last sentence > and frankly I'm becoming very weary of seeing that sentiment > put forth. Understood. > As much as I may disagree with some of the ideas espoused by Richard > Stallman, I wholeheartedly agree with his notion that application > software lacking properly prepared documentation shouldn't be released > until that defect has been fixed. Period. Certainly this is the ideal to which all projects aspire. Some get there, some don't. For instance, GNOME, the latest GNU darling, went out the door with docs probably below the standard we're at. Like us, though, the GNOME folks had to balance a whole host of influences. > I doubt that the documentation writer DC has hired will ever catch up > in the current climate. I doubt that DC will ever achieve its goals > until that problem is addressed. If I were running DC, I'd declare the > following policy, effective immediately: > > """The current feature freeze on 2.0 will now be supplemented by a > development freeze. All developers, salespeople, in fact anyone with a > brain and a pair of eyes and hands, will reassign themselves to > supporting the documentation effort until that effort has come abreast > of the current and near-term development. Henceforth, we will *not* > release until documentation is in hand.""" Since I'm the guy running DC, I'll chime in by saying that our goal after 2.0 is to slow way down and harden what's already there. We _all_ know that we have plenty of powerful ideas, and that we certainly don't need boatloads of new code to stay ahead. What is needed the most is better explanation of what is already there. We'll never go to the extreme that you've articulated, as Zope is always moving forward based on consulting engagements, and those won't be held up while documentation for the general case is concluded. But it is most certainly our goal to move to a model where the pure Zope work starts with documentation and isn't released until the documentation is released. The closer we get to that goal the better. Just my $0.02. --Paul Paul Everitt Digital Creations paul(a)digicool.com 540.371.6909 ----------------------------------------- The Open Source Zope application server http://www.zope.org/

1 0

RE: [Zope] How can I examine an property of an object from the ot her object in the other tree?
by Michel Pelletier 16 Aug '99

16 Aug '99

> -----Original Message----- > From: kslee(a)plaza1.snu.ac.kr [mailto:kslee@plaza1.snu.ac.kr] > Sent: Monday, August 16, 1999 12:35 PM > To: Michel Pelletier; zope(a)zope.org > Subject: Re: [Zope] How can I examine an property of an > object from the > other object in the other tree? > > > Thank you for your reply with apology for non-plain text mail > & varous typos. > > After a shower and your reply, I can refine my question. > > As you wrote,  works OK. > (docTest is DTML Document and TR is its property) > But only as far as I *hard code* into every DTML Document > such a line(yes there is a way to hard code such a line into > every DTML Document if I have to but it seems too foolish and > complicated). > > Is there a way to write *ONE* DTML code and use it in every > DTML Document? > This is what acquisition is for. Acquisition allows you to factor out common components of your application into services available to all or some of your objects depending on their placement in Zope reletive to the component in question. For your problem, create a DTML Method in the root level folder named 'isTR' containing:  English  Korean  Now lets say you have a DTML Document called /korean/docs/one whose TR property is set to '0' (meaning there is no english tranlation). Going to /korean/docs/one/isTR will print 'Korean'. What happened is the 'one' Document *acquired* 'isTR' from the root folder. It can acquire from any object 'above' it in the object heirarchy. By this reasoning, it stands that everything in the root folder is acquireable. > I wrote in the root folder an one liner DTML method 'isTRed' which is >  > > It gives the string english.members.test.docTest.TR > when called in the DTML Document /korean/members/test/docTest > as . > > But  gives the source of isTRed method. > And  gives attribute error. >  gives the string > english.members.test.docTest.TR as might be > expected. > You want  Quoting the var argument makes it be evaluated as an expression. Not quoting it makes Zope use it by name. If you quote a DTML Method or Document, you must *call* it to get it to render the document. In this case however, refering to the document by name will call the document for you:  > Please don't laugh at my silliness, : (. > > Any revelation? > > TIA > > LEE Kwan Soo. > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

Zope Mentioned in IBM dveloperWorks
by Alastair Burt 16 Aug '99

16 Aug '99

Another "how to make money from open source software" reference: http://www.software.ibm.com/developer/library/license.html --- Alastair

1 0