Re: [Zope] multiple selects are not allowed
Hi, Thank you for your answer. At 15:19 13-12-00 +0100, Dario Lopez-Kästen wrote: - Original Message - From: "Jose Soares" [EMAIL PROTECTED] Subject: Re: [Zope] multiple selects are not allowed from ZSQL Methods User's Guide, last row on pag. 22: "Note that no more than one SQL select statement may be used in a single SQL Database Method." Diny, why do you need to execute multiple selects in one SQL-Method? Belief me, you don't want to know ;) I'm building a database application for the drugstore department. Veterinarians can find medicines by searching on animal, ingredients, diseases etc. When they've found one medicine all the detailed information about this particular medicine is being displayed. At this point i thought i could use the multiple selects. The medicine has a 1 to many relationship with animals, ingredients, diseases etc. all stored in different tables. When i use one single select statement with several where conditions, and one relationship isn't filled, the query returns nothing at all. Maybe there is another way of doing it? I'll split up one complex ZSQL method into several simple methods. Regards, Diny DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] multiple selects are not allowed
Hi, I want to execute multiple SQL statements in one SQL-Method. In the mailinglist archives i found the answer but when i try it i get an error: Error, exceptions.ValueError: multiple selects are not allowed I used a simple Z SQL Method query (Zope 2.2.2) just to try: select * from GENEESM_DIER dtml-var sql_delimiter select * from TOED_WIJZE What am i doing wrong? Diny DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Microsoft Access database
At 23:07 22-11-00 -0500, John Cappelletti wrote: [...] What is the process for connecting to a MS Access database? Can it be done? Yes, it can. I'm running Zope 2.2.0 on Windows98 with Access97. You'll have to use the ZODBCDA product. In Windows98: - Use the Control Panel - ODBC connection - Add a system DNS - Select the MS Access driver - Fill in an alias name and select the database you want to use In Zope: - Add a Z ODBC database connection - Select the alias you defined above and Add Diny DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] How many houres do I need to manage a Zope site?
Hi, The management team wants to know how many hours are necessary to keep the faculty Zope site running. I have to make a summary of hours necessary for the technical system management such as software releases, database management, fixes etc. Developing or installing new features is not to be included. Configuration: Zope version: 2.2.2 Windows NT 4.0 Installed products: FSSession, LocalFS, Refresh, Squishdot, TinyTable, UserDB, XMLDocument, XMLWidgets, ZODBCDA, ZSQLMethods 1. How many Zope releases per year can I expect and how much time do I need per release? 2. How much time do I need for product releases and fixes? 3. How much time do I need for Zope database management? Besides a regular backup and packing the Data.fs are there other things necessary? Do I miss important tasks? Has anybody done this before? Thanks, Diny DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] LocalFS on Win2k
Hi, I had the same error with LocalFS on a NT 4.0 server. In my case it was a security problem. Zope wasn't allowed to access the directory I used. Now I placed my local files in a directory Zope is allowed to read and everything is working fine. Diny At 18:11 11-10-00 -0400, Patrick Randerson wrote: I'm trying to run LocalFS on Win2K, and access shared disks. I've read the instructions for the LocalFS package and followed them... When I try to access the LocalFS directory, I get: Error Type: OSError Error Value: [Errno 5] Input/output error I'm thinking this is a python-windows interface problem. I have Zope 2.2.2, which seems to come with PyWin build 128. I have found a build 132, but I can't install it because I don't have python installed -- only standalone Zope. Anybody using LocalFS to access shared drives on Win2k? I would love some pointers here... DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Imagemap in an image object
At 11:36 25-8-00 +0200, Radim Gelner wrote: Greetings, is there an easy way to add imagemapping to an image object or do I have to create a new class for such a purpous? I don't know exactly what you mean by imagemapping, but if you mean the html tag map then you can use something like this in your dtml-method: img src="image_gif" border="0" usemap="#home" map name="home" area shape="rect" coords="1,1,460,310" href="url" /map Diny DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] building a Python module on Winnt
At 11:37 24-8-00 +0100, Vincent wrote: Hi, How can I build a python module on Windows NT ? Thanks Vincent Well, I only know how it's done on Windows NT: I use Idle (python.org) to make the .py file, then put this python file into the Extensions directory of the Zope installation. Then in Zope add an external method. Diny DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] newbiz : zope connection
At 09:49 24-8-00 GMT, Stephan Goeldi wrote: Zope 2.2 has a facility in its Control Panel where you can see, how much requests are currently in work. What is the "Control Panel" and where can I find it? You got to have the manage role, then you find it in your Zope root folder contents. Diny DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Importing problems
At 09:15 2-8-00 +0200, Marko MARKOVIC wrote: Hi all, How can i import objects from 2.1.6 to 2.2.0? I can import them but couldn't view them, some authorization problems. Is that a known problem? If you're using sql methods then this might cause the autorization error. There is a patch available at: http://zope.nipltd.com/public/lists/zope-archive.nsf/ByKey/1B0EA8EF64524A02 Diny DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] zope.org down
Hi, After downloading the InterBase 6.0 check the version of IBConsole because the 309 version is corrupt. When you try to connect to a database you'll get the following message: "error connecting to database" ... "DPB Constant (0) is unknown" Download the 308 version of OBConsole at: http://www.interbase.com/open/downloads/ib_download.html Diny At 17:57 29-7-00 +0200, [EMAIL PROTECTED] wrote: Chris Withers wrote: Chris McDonough wrote: The InterbaseStorage product is full-featured (undo, versioning). But I've gotten little response to releasing it, and I don't think anyone is using it, so bugs are sure to exist. I don't think you announced this loudly enough ;-) Is interbase stable/OSS? Yes, it has been developed by Borland/Inprise commercially for many years. They open-sourced it recently, going through a long beta period. Where can I get it from? http://www.inprise.com Where is the InterBaseStorage product (and documentation ;-) available? See the ZopeTreasures page Beehive has set up. A nice piece of work in tasteful day-glo colors :-) Jan ___ Zope maillist - [EMAIL PROTECTED] 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 ) DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] SQL and customise screen
At 09:38 27-7-00 +0100, Vincent DELHOMMOIS wrote: Hi, I would like to use an SQL request to search some data in an access database. The request need to be executed when somebody clic on a button (onclick="") The result need to be displayed on the screen, but not on one line. I must be able to place the results in different places on the document. May be you could use something like this: form action="mylist" method="get" table tr tdinput type="submit" value="Click here"/td /tr /table /form mylist (dtml-method): dtml-let results="sql.selectWhatYouWant(REQUEST)" table dtml-in results dtml-var yourdisplaymethod /dtml-in /table /dtml-let In yourdisplaymethod (dtml-method) you can specify where you want to place your results. Diny DIVA Faculty of Veterinary Medicine Utrecht University The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Running Zope 2.2 on Solaris 2.7
At 16:41 19-7-00 +0200, Andreas Rippel wrote: I installed Zope 2.2 for Solaris 2.6 on Solaris 2.7. After starting an accessing as superuser I wanted to add an object e.g. a folder. I couldn't add any kind of object, while getting messages like Hi, First you have to create another user and give it the manager role. Then close all instance of your browser, login again as the new user you've just created. This user can add objects. Diny DIVA Faculty of Veterinary Medicine Utrecht University The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope-dev] Re: [Zope] site versions with zope
At 10:38 4-7-00 +0200, Nathalie Bernier wrote: Hello, I'd like to modify a live site, instead of working on a mirror copy. Could someone explain me, step by step, how sessions work? Hi, At http://www.zope.org/Documentation/Guides/ZCMG (Zope Content Manager's Guide) you'll find a section called 'Working with versions'. May be this is what you are looking for. Diny. DIVA Faculty of Veterinary Medicine The Netherlands http://www.vet.uu.nl ___ Zope-Dev maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] site versions with zope
At 10:38 4-7-00 +0200, Nathalie Bernier wrote: Hello, I'd like to modify a live site, instead of working on a mirror copy. Could someone explain me, step by step, how sessions work? Hi, At http://www.zope.org/Documentation/Guides/ZCMG (Zope Content Manager's Guide) you'll find a section called 'Working with versions'. May be this is what you are looking for. Diny. DIVA Faculty of Veterinary Medicine The Netherlands http://www.vet.uu.nl ___ Zope maillist - [EMAIL PROTECTED] 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 )
