- Zope - Zope lists

no result of change in products python methods
by Olaf Zanger 08 Jan '01

08 Jan '01

hi everybody, my changes in the sql parts of the python files of the zbabel product do not show changed behaviour in the product after restart of zope. what could be the reason? do i have to do anything with python too? setup is Zbabel 0-0-3, ZMySQLDA 1-2-0, MySQLdb 0-1-2 and zope 2-2-4 thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:info@soli-con.com mailto:olaf.zanger@soli-con.com http://www.soli-con.com

1 0

zpattern compiling
by Olaf Zanger 08 Jan '01

08 Jan '01

hi everybody, after a long weekend i still searching ExtensionClass.h where is it supposed to be, it is called by cPersistence.h when compiling zpatterns does it come with zope, zpattern or python? where do i get the Makefile.pre.in from? can i copy it from MySQLDB-1.2.0? thanks for help olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:info@soli-con.com mailto:olaf.zanger@soli-con.com http://www.soli-con.com

1 0

filename extension
by Olaf Zanger 08 Jan '01

08 Jan '01

hi there, some information on zope.org says that in the early future ftp access should be possible not only to dtml-methods, -documents but also to Zsql-methods. to be future proof (and windows software proof) we'd like to have .xxx extensions for all our methods (fac_browse_method.sql that lovely windows understands what programm to start [textpad for sql ...]) unfortuanetly if called like <dtml-in expr="fac_browse_method.sql(id=10)"> zope gernerates an error. if there is a solution: how? or if not: does anything needs to be changed in the file handling of zope thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:info@soli-con.com mailto:olaf.zanger@soli-con.com http://www.soli-con.com

1 0

Persistence in Zope
by Heinz-Josef Claes 08 Jan '01

08 Jan '01

Hallo, gibt es eigentlich eine (einfache) Möglichkeit, Daten (-strukturen) in Zope persistent zu halten? 1. Um einen schnellen Zugriff auf Daten zu haben (Die Daten werden z.B. in Hashes vorgehalten) 2. Um Transaktionen durchführen zu können (Wiedererkennen des Anwenders z.B. über cookies) Der erste Fall hat mit dem zweiten nicht unbedingt was zu tun. MfG, Heinz-Josef Claes

1 0

Re: [Zope-dev] MySQL with LAST_INSERT_ID()
by Philipp Auersperg 08 Jan '01

08 Jan '01

Be careful with last_insert_id() and similar sql functions and Zope and more than one simultanous user: since all requests run over the same physical database connection, it is not guaranteed that your call last_insert_id() returns YOUR last inserted record ID. if another user performs an insert in the right moment you get HIS last id. the scenario: user1 inserts (gets ID 42) user 2 inserts (gets ID 43) user1 calls last_insert_id() (gets 43) phil *********** REPLY SEPARATOR *********** On 08.01.2001 at 08:27 Arno Gross wrote: >Dieters assumption was right. >LAST_INSERTED_ID() returns a numeric value and >that seems to be the problem. So if I change the statement as this: >SELECT CONV(LAST_INSERT_ID(),10,10) >it works (CONV returns a string!) > >P.S. Soren, maybe you can update your HowTo with a short note. Another >possibilty instead of using LAST_INSERT_ID can be using MAX(). That should >work too. > >Thanks > Arno >On Sat, 06 Jan >2001, Dieter Maurer wrote: > Arno Gross writes: >> > SELECT LAST_INSERT_ID() >> > >> > This method works with Zope 2.2.4 under Linux and MySQL 3.22.32 >> > but I got an error with Zope 2.2.2 under NT 4.0 and MySQL 3.22.29 >> > Error, exceptions.KeyError: unhandled >> Sieht aus, als k�nnte der MySQL Anschluss den >> R�ckgabewert von "LAST_INSERT_ID" nicht in einen Python >> Datentyp wandeln, w�rde deshalb gerne eine "unhandled" >> Funktion aus einen Dictionary auslesen, die leider >> nicht drin ist. >> >> Sieht f�r mich nach einem Upgrade auf eine neuere Version >> von MySQL bzw. seinen Python Anschluss aus. >> >> Allerdings m�sste man zun�chst den Traceback genau anschauen, >> ob meine Vermutung auch wirklich zutrifft. >> >> >> Dieter >------------------------------------------------------- > >_______________________________________________ >Zope-Dev maillist - Zope-Dev(a)zope.org >http://lists.zope.org/mailman/listinfo/zope-dev >** No cross posts or HTML encoding! ** >(Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope )

1 0

Seminar on Zope at City University, London, UK on 15th Jan
by Paul Browning 08 Jan '01

08 Jan '01

For any London-based readers who might be free next Monday evening (especially if you know the answer to the question posed in the seminar title!). Please contact Robert if you plan to come. Paul > Date: Tue, 19 Dec 2000 11:29:08 +0000 > From: Robert Bristow <R.N.Bristow(a)CITY.AC.UK> > Subject: .gamut - 2001 > > Two meetings have been scheduled for 2001, following the > cancellation of the meeting in October. > > 1. 15th Jan 2001. 6.30 pm Dr Paul Browning, University of Bristol. "Buy or > Build > a content management system? Where does Zope fit in?" In addition Bill > Mackintosh and Robert Bristow will give a brief overview of web > developments at City University. > > Location - Executive Developemnt Suite, City University Business School, > 1st floor, 24A Chiswell Street, London EC1Y 4TY (Corner of Bunhill Row and > Chiswell Street) > > 2. 26th February 2001. Professor Clive Holtham will share his experiences > of working with public sector bodies on knowledge management issues and > the problems such bodies face in getting their message across. > > Location - Executive Developemnt Suite, City University Business School, > 1st floor, 24A Chiswell Street, London EC1Y 4TY (Corner of Bunhaill Row > and Chiswell Street) > > http://www.multimap.co.uk/clients/browse.cgi?client=M6&db=pc&pc=EC1Y4TY&SUB MIT=Find&quicksearch=ec1Y+4ty&client=M6 > > At each session there will be time for general discussion of issues facing > institutional web managers and others and time to continue the discussion > in a local city pub afterwards. > > Anyone involved in managing, or otherwise the web in institutions, HE, FE, > local or central government, the voluntary sector or other complex > organisations is welcome. The aim of .gamut is to provide a forum for > debate, support and for getting to know one another, > > Any questions etc please call Robert Bristow (robert(a)city.ac.uk) on 020 > 7477 8300 or Bill > Mackintosh (W.Mackintosh(a)city.ac.uk) on 020 7477 8782. > > Please let me know if you are coming - for room booking and catering > purposes. We will be providing Tea, Coffee and soft drinks on arrival. > > Oh yes, have a happy christmas! > > Robert > --------------------------------------------------------------- > Robert Bristow - World Wide Web Coordinator > City University Business School > Frobisher Crescent, Barbican Centre, London, EC2Y 8HB > Tel +44 (0)20 7477 8300 > e-mail: robert(a)city.ac.uk > http://www.business.city.ac.uk > -------------------------------------------------------------- -- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning(a)bristol.ac.uk URL: http://www.bris.ac.uk/

1 0

Re: [Zope] RSS and JavaScript
by Holger Lehmann 08 Jan '01

08 Jan '01

Am Montag, 8. Januar 2001 04:11 schrieben Sie: > On 7 Jan 2001 17:51:24 -0800 LARRY CHUON <lchuon(a)telocity.com> wrote: > > Hi Zopistas, > > > > Happy New Year! --snipp-- > ....Or do what you did before: > > <SCRIPT LANGUAGE="JavaScript" SRC="<dtml-var > expr="openMe_js.absolute_url()">"></SCRIPT> This will also do the trick: <script language="javascript" src="<dtml-var openMe.js url>"> - Holger > Use the absolute_url() method, so that the browser is sure of getting the > right url for the script (which may have been your problem before). > > I'd use the first method as you can at least eyeball the html output of > htmlPreview and see if the openMe function has acutally been include, > before having to use whatever passes for javascript debugging in your > browser. > > HTH, > John > > > _______________________________________________ > 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 ) -- ----------------------------------- catWorkX GmbH Dipl.-Ing. Holger Lehmann Stresemannstr. 364 22761 Hamburg Tel: +49 (0700) catWorkX Tel: +49 (40) 890 646-0 Fax: +49 (40) 890 646-66 mailto:lehmann@catworkx.de http://www.catworkx.de http://www.catbridge.de

1 0

Problem on searching the record
by Angietel 08 Jan '01

08 Jan '01

The following is my sql method, it can return result even i only enter one alphabet in custname but it can't work when i enter data into the custid. select * from customer where custid='<dtml-var custid>' OR custname LIKE "%<dtml-var custname>%" P/s let me know where is my error.TQ

1 0

Re: [Zope] "SELECT ... AS ..." statement in ZSQL
by Dario Lopez-K�sten 08 Jan '01

08 Jan '01

----- Original Message ----- From: "Bowyer, Alex" <BowyerA(a)logica.com> > A simple question, but I can't seem to find a simple answer in any of the > documentation... > > How do you do a SELECT AS statement in a ZSQL method? > > For example > SELECT FirstName + " " + LastName AS FullName > hmm... shouldn't that be SELECT FirstName || " " || LastName as FullName I am bit unsure of the proper syntax (I am mostly working with Oracle), but I think you use "||" to concatenate two strings in SQL. /dario - -------------------------------------------------------------------- Dario Lopez-Kästen Systems Developer Chalmers Univ. of Technology dario(a)ita.chalmers.se ICQ will yield no hits IT Systems & Services

1 0

How to escape quotation mark in dtml script?
by Dirksen 08 Jan '01

08 Jan '01

<dtml-call "REQUEST.set('a', '\"b\"')"> won't work! Please help. Dirksen __________________________________________________ Do You Yahoo!? Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/

1 0