- Zope - Zope lists

RE: [Zope] Non-query SQL with Zope (naive question)
by Jeffrey Shell 24 Aug '99

24 Aug '99

> It would appear that I was too quick to think I failed. When you test the > output screen states the "This is not a query". After getting errors earlier > due to malformed SQL, I assumed this was an error too. I was expecting > something along the lines of what the command line would give, like > "Inserted 1", indicating that I was successful. Live and learn. The results returned (on the test screen) on non-selects vary from database to database. The Sybase DA returns a full suite of interesting results, other DA's return nothing (and Zope at that point says "This was not a query").

2 1

FYI - Python/Zope Article
by Robert Leftwich 24 Aug '99

24 Aug '99

There was an article (http://buzz.builder.com/cgi-bin/WebX?14@101.PwqganhkenJ^0@.ee7bc67/0) on Builder Buzz by Dan Shafer describing Python as 'The Most Elegant Scripting Language You'll Probably Never Use' that mentions Zope and calls for some feedback on the pros and cons of Python - which should be a good opportunity for the Zope community to spread the word. Robert Leftwich

2 1

Red Hat commentary
by Jeff Bauer 24 Aug '99

24 Aug '99

Hidden at the bottom of an interesting commentary by John Zedlewski: http://www.osopinion.com/Opinions/JohnZedlewski/JohnZedlewski1.html "Building E-Businesses with Red Hat ZopeServer" -Jeff

2 1

RE: [Zope] Non-query SQL with Zope (naive question)
by Martijn Pieters 24 Aug '99

24 Aug '99

At 18:25 24-8-99 , Michel Pelletier wrote: >> >  >> > >> >Is that equivalent to the browser doing >> >http://site.com/path/to/method/insertNewContact?name=Matin+Pi >> eters?email=mj@ >> >antraciet.nl >> >> No, but the REQUEST.set does do the same. >> > >Hmm. maybe we're talking about something else here (I just jumped in on >this thread) but the #call above is synonymous, although not identical, >to the URL below it. I would have answered this question yes, but maybe >i'm missing something germain to the discussion. It has the same result, but from a technical point of view, it is different. I gave two examples, one where I passed in the parameters directly, and one where I passed them in via the REQUEST object. Calling the SQL method via a URL with the parameters encoded in the qury string, is more like setting the parameters in the REQUEST object then calling the method fomr DTML with the parameters as part of the method call. -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | T: +31 35 7502100 F: +31 35 7502111 | mj(a)antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ---------------------------------------------

2 1

Something want to ask you!
by Elaine Kong 24 Aug '99

24 Aug '99

Hello Stephan, You had send your news directory to me. I want to ask you some question about it. The file that you sent to me is (news.zexp). Which type is the file ? How can i open it by using which software? Where can i put it? Hope you can reply my letter as fast as you can.Thank you very much. Elaine Kong. My E-mail address : elainekong(a)hutchcity.com

1 0

RE: [Zope] Non-query SQL with Zope (naive question)
by Michel Pelletier 24 Aug '99

24 Aug '99

> -----Original Message----- > From: Martijn Pieters [mailto:mj@antraciet.nl] > Sent: Tuesday, August 24, 1999 11:56 AM > To: Bruce Elrick > Cc: zope(a)zope.org > Subject: Re: [Zope] Non-query SQL with Zope (naive question) > > > At 16:49 24-8-99 , Bruce Elrick wrote: > >By the way, in your message you showed this way of calling > the SQL Method: > > > >  > > > >Is that equivalent to the browser doing > >http://site.com/path/to/method/insertNewContact?name=Matin+Pi > eters?email=mj@ > >antraciet.nl > > No, but the REQUEST.set does do the same. > Hmm. maybe we're talking about something else here (I just jumped in on this thread) but the #call above is synonymous, although not identical, to the URL below it. I would have answered this question yes, but maybe i'm missing something germain to the discussion. > You would do better setting the target of the form to a DTML > Method that > does the call to your SQL method, because that way you can give custom > feedback. > Yes this is true. -Michel

1 0

Non-query SQL with Zope (naive question)
by Bruce Elrick 24 Aug '99

24 Aug '99

Hi all... I'm just discovering Zope, have installed v1.10.3 on Linux, am using Zserver for the http server, and am using PostGreSQL with ZPyGreSQLDA. I was happily developing my web site, including creating queries of a PostGres DB, when I found that I could not create insert, update, or deletion SQL commands. The docs support this fact, but I can't believe that people have not wanted to do more SQL beyond just querying. I'm guessing that I could write some Python extensions to do that sort of thing, but I'm not a Python programmer and I have to believe that someone else wants to do this and is working on it already. I imagine the features of the SQLMethods included with Zope would be as useful in non-query SQL as they are in querying. I haven't delved into v2 and the ZClasses that are available there. Looking at the contributed Products for v1 on the Zope site, I could not see anything that addressed this. Update: I found sqlinputwix1.0.tar.gz, which from the name I can only hope is what I want, but it is MySQL only. I haven't tried setting up a MySQL DB just to see what functionality is provided by this Product. How do people make full-fledged web applications with DB back ends using Zope? Or do they even try? How does one get information about the contributed Products without actually installing and tryinig them out? Cheers... Bruce -- Bruce Elrick, Ph.D. Saltus Technology Consulting Group Cell: (403) 870-4429 Personal: belrick(a)home.com IBM Certified Specialist Business: belrick(a)saltus.ab.ca ADSM, AIX Support, RS/6000 SP, HACMP

3 5

Re: [Zope] simple dtml question
by Martijn Pieters 24 Aug '99

24 Aug '99

At 17:23 24-8-99 , Tim Wilson wrote: >Hi everyone, > >Why doesn't this work? I hesitate to ask because I'm sure it's a simple >answer. It's a DTML Method in the / folder. The button image is also in /. > ><center> ><a href="http://www.adobe.com/prodindex/acrobat/readstep.html"><img >border=0 src="<dtml-var acroread_button>"></a> ></center> What happens when you call an image (like <dtml-var acroread_button> does), Zope will insert a complete image tag for you: <img src="/acroread_button" width=xx height=xx alt="title of the acroread_button object"> Because you insert this inside another IMG tag, you end up with the following: <center> <a href="http://www.adobe.com/prodindex/acrobat/readstep.html"><img border=0 src="<img src="/acroread_button" height=xx width=xx alt="title of the acroread_button object">"></a> </center> which makes no sense to your browser. You want to do one of the following: <center> <a href="http://www.adobe.com/prodindex/acrobat/readstep.html"><img border=0 src="<dtml-var "acroread_button.absolute_url()">"></a> </center> which inserts the URL of the image object, or: <center> <a href="http://www.adobe.com/prodindex/acrobat/readstep.html"> <dtml-var acroread_button></a> </center> which inserts the whole IMG tag, including width and height, but you'd be missing your 'border=0' and have an alt attribute extra. The following code will insert an IMG tag with 'border=0', and without the alt attribute: <center> <a href="http://www.adobe.com/prodindex/acrobat/readstep.html"> <dtml-var "acroread_button.tag(alt='', border=0)"></a> </center> -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | T: +31 35 7502100 F: +31 35 7502111 | mj(a)antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ---------------------------------------------

1 0

Python + PHP
by Arnaud Lecat 24 Aug '99

24 Aug '99

Hi Can PHP and Zope (Python?) live together on a same server ??? I mean live in peace... :) -- >> WinErr: 080 Clavier introuvable - Veuillez appuyer sur n'importe quelle touche pour continuer. << Arnaud LECAT >> Email: lecat(a)hexanet.fr >> WWW page:www.hexanet.fr/~lecat HEXANET >> http://www.hexanet.fr Z.A. Farman sud - 9 rue Roland Coffignot BP 415 - 51689 Reims Cedex 2 - France phone: (33) 03 26 79 30 05 Fax: (33) 03 26 79 30 06

5 7

RE: [Zope] a funny thing happened today...
by Paul Everitt 24 Aug '99

24 Aug '99

A brief note, FWIW -- Mozilla has now grafted XSL support into their codebase. Believe it or not, someone sent in the patches :^) Thus, client-side XSL might not be an "IE5 but broken"-only arrangement. --Paul > -----Original Message----- > From: Tony McDonald [mailto:tony.mcdonald@ncl.ac.uk] > Sent: Tuesday, August 24, 1999 3:34 AM > To: Martijn Faassen; Zope List > Subject: Re: [Zope] a funny thing happened today... > > > At 10:38 am +0200 23/8/99, Martijn Faassen wrote: > > > >> I've been watching the XML-L and XML-DEV lists for, oh 18 > months now. > >> There have been announcements of rendering XML into HTML etc on the > >> fly, yes. But the solutions offered have always been too clunky for > >> me (talk of XSL and Java servlets and *much* more arcane stuff flew > >> around and through the list and my head for many moons). > > > >I know next to nothing about XSL and Java servlets. I'd like to study > >XSL sometime, is it really that arcane? I read something > about DC going > >to fit XSL into Zope, so I'm curious about it. > > > > I initially got turned off by some of the pontificating on the XML > lists (discussions of XSL, XSLT, XSL FOs - just seemed too complex to > me). It seemed to me like people were investigating things from a > research angle and not from an implementation viewpoint (which is ok, > but I wanted implementations). > > Having said that, recent posts on XML-DEV, imply that things may be > simpler than I thought - I won't post the example I *did* have, as > this is a Zope list, not an XML list! :). That, along with the fact > that the XMLDocument product works well and DC have mentioned > something about XSL too, is pretty good news. I wouldn't expect > anything big to happen in that arena until Zope 2.1 is out (before > people go looking, Zope 2.1 *does not exist*, DC have said they are > feature freezing 2.0 and making it stable, before embarking on new > functionality). > > tone. > ------ > Dr Tony McDonald, FMCC, Networked Learning Environments Project > http://nle.ncl.ac.uk/ > The Medical School, Newcastle University Tel: +44 191 222 5888 > Fingerprint: 3450 876D FA41 B926 D3DD F8C3 F2D0 C3B9 8B38 18A2 > > _______________________________________________ > 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