- Zope - Zope lists

how to skip duplicate zsql results?
by Wayne Connolly 30 Jul '03

30 Jul '03

i have a simple zsql (select * from table) which returns a list of items. The problem is that it returns identical items. Ie 1. item 1 2. item 1 3. item 2 How can i make it skip/omit the second duplicate entry. Below is the code. <SELECT name="item"> <OPTION tal:repeat="table here/getTableMethod"><SPAN tal:replace="table/item">Some Item</SPAN></OPTION> </SELECT> Thanks, Wayne __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

4 4

Using MySQL from a product
by Carsten Gehling 30 Jul '03

30 Jul '03

I amd creating a product, that needs to communicate with MySQL (inserting/updating records and making select queries). I've installed MySQLdb and Z MySQLDA and can easily create connections from ZMI. I don't know however, how to communicate directly with MySQL from my product. Should I rely on a connection created in ZMI? Or do I create my own connection - if so: how? And how do I make the queries? - Carsten

3 4

display directory/files tree in LocalFS
by helma 30 Jul '03

30 Jul '03

How can I display a real directory directory in a LocalFS object where I can select a directory or file ? + Directory + Directory - File1 - File2 + Directory - File1 Greetings. Helma

1 0

ExpansionTree
by Pascal Samuzeau 30 Jul '03

30 Jul '03

Hi Jamie, I need a product similar as ExpansionTree. I've downloaded it and tried. I need your little help for a special case. But first I've to changed your ZPT named et-examples/by-query in your example, to avoid this error: ******************************************************* __traceback_info__: {'path': ['absolute_url'], 'TraversalRequestNameStack': []} TypeError: sequence index must be integer ******************************************************* ******************************************************* line 12: - tal:define="o r.object;url string:${o/absolute_url}/manage_workspace" + tal:define="o python:r.object;url string:${o/absolute_url}/manage_workspace" ******************************************************* Ok, now my really question. In fact I've have the same problem in two cases, and I intend to change your product to answer to it, so I need your help. 1- I have Folders and content as: Members --MemberA ----FileA ( Type A ) ----FileB ( Type B ) --MembreB ----FileC ( Type A ) What I need is to get a tree as: Root: the Type of Members/MemberA/FileA, recognize as a folder root Subfolder (if one exist, not in this case I think) Leaves : FileA,FileC I've tried with some function, but I've still not find anyone. 2- I've a Forum as: Forums --ForumA ---YearX ----MonthX -----DayX ------Post1 ------Post2 (Answer of Post1) -----DayY ------Post3 (Answer of Post1) ------Post4 (Answer of Post2) What I want is a tree as : Root: Title of ForumA Subfolders: PostX (which have answers) Leaves: PostY (without answers) But for this I need to change in a fly the function calling in the setChildChooser's method. Have you any idea of how I'm able to do it? Is there any similar product which does what I need? Cheers PS -------------------------------------------------- Oreka ! Nous sommes l'internet moins cher ! Surfez 25% moins cher avec http://www.oreka.com

2 1

testing
by Jaroslav Lukesh 30 Jul '03

30 Jul '03

Sorry, but I does not see my mails to zope(a)zope.org for >24 hours.

1 0

ZPT/ZSQL optional where problems
by Wayne Connolly 30 Jul '03

30 Jul '03

Hi I have a form that i wish to do the following: 1.submit to itself (no probs here) 2.allow multiple optional criteria in form 3. render results(no probs here) It doesnt seem to work and just returns all cats and dogs instead of doing the correct filters. Below is the form and sql method..i cant see whats wrong. ZPT: index_html -------------- <FORM name="form1" method="post" action="index_html"> <SELECT name="cat"> <OPTION>Select a cat</OPTION> <OPTION tal:repeat="cat here/animalBrowseMethod"><SPAN tal:replace="animal/cat">cat</SPAN></OPTION> </SELECT> <SELECT name="dog"> <OPTION>Select a dog</OPTION> <OPTION tal:repeat="dog here/animalBrowseMethod"> <SPAN tal:replace="animal/dog">dog</SPAN></OPTION> </SELECT> <INPUT type="submit" name="submit" value="Get animals"> </FORM> --------------- ZSQL: animalBrowseMethod -------------------- select * from animal <dtml-sqlgroup optional where> <dtml-sqlgroup> <dtml-sqltest cat column=cat type=nb multiple optional> <dtml-or> <dtml-sqltest dog column=dog type=nb multiple optional> </dtml-sqlgroup> </dtml-sqlgroup> ---------------- __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

2 2

multiple mounted storages served by ZEO?
by Christopher N. Deckard 30 Jul '03

30 Jul '03

I looked at the DBTab Product. It meets a lot of needs of separating databases to, for example, individual users. I'm not quite clear if it can do what I need though. DBTab lets you mounts multiple storages, including those served from a ZEO server. What I would like to be able to do, is to have a single ZEO server serve up the objects. That way if I have multiple ZEO clients, I don't have each one mounting all of the databases. Would this be at all possible? At the moment I have a single server, but I am running Zope in a ZEO configuration. As clients sign on, I want to be able to put their Data.fs file where I can keep track of quotas. I would potentially have other ZEO clients, but I don't want to run a ZEO server instance for each ZODB I want to mount on multiple ZEO clients on multiple physical servers. Maybe what I'm asking is insane. :-) Please let me know your thoughts. -Chris

3 3

Upload files and TimeStamp format
by Christian Pizzuto 29 Jul '03

29 Jul '03

I've posted my problem in Italian Forum and had no answer. I'm newbie in zope and python, and I made a form for uploading files into Zope folders. The problem is that the name of the folder in which uploading the file, is in a variable called "nomecartella" and is like "Intranet.Bandi.bando18". The code I used is: <dtml-call "_[nomecartella].manage_addFile(nomefile, file, titolofile)"> where nomecartella is the variable that contains the path of the folder that I want contains the uploaded file; nomefile is the id of the file I want upload; titolofile is the name of the file. But I get an error: Error Type: KeyError Error Value: Intranet.Bandi.bando18 If I replace _[nomecartella] with Intranet.Bandi.bando18 it works !!!! Any ideas? Another question: I've a set of records in a MySQL DB having a TimeStamp field. I made a SQL method for retrieving all the records between two dates typed in by the user ( in format %d/%m/%Y). I used this code: select ... from ... where ... and "_.DateTime(time) >= <dtml-var "ZopeTime(p_dal + _.str(' 00:00:00.000 GMT+2'))"> and "_.DateTime(time) <= <dtml-var "ZopeTime(p_al + _.str(' 23:59:59.000 GMT+2'))"> where time is the TimeStamp field into the DB; p_dal and p_al are the two dates that make my range. I get this error: Error Type: ProgrammingError Error Value: (1064, "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '_.DateTime(time) <= 2003/07/21 23:59:59 GMT+2 LIMIT 1000' at li") What to do?

2 1

Handling objects versions
by Thierry Florac 29 Jul '03

29 Jul '03

Hi, I'm currently using Zope (2.6.1) to drive out intranet site with the help of several custom products I've written. I'd like to be able to handle versions for instances of several custom classes (like documents or articles), and I'm looking for existing products, how-tos or classes which may help me in that task. Also, for your information : - I'd don't use CMF or CPS or Plone ! - versions creation is a manual operation, not linked with existing Version product or history management (which is lost after packing) - older versions don't have to be updatable - versions handling should be available for simple items as well as object managers (Folder, OrderedFolder...) or BTree managers (BTreeManager2...) - of course, access to old versions have to be easy, throught a simple URL... Thanks for any advise, link, doc... Thierry -- Linux every day, keeps Dr Watson away... http://gpc.sourceforge.net -- http://www.ulthar.net

2 1

Zope on AMD64
by Job, James 29 Jul '03

29 Jul '03

Has anyone had any luck with Zope on AMD/64? I tried to do the source build (Python, ZOPE source) on Mandrake 9.0/X86_64, and usually end up with messages of the Zserver having a SEGDEV fault (error 200) on startup, and it just loops through trying to restart the service. I'm assuming there is a compiler problem here somewhere. Python appears to be ok. Mandrake comes with Python 2.2, but I did a separate source compile with 2.1.3. The i386/Linux install works fine. Any advice would be greatly appreciated. Thanks, James Job Washington State Employment Security Department Webmaster ESD CONFIDENTIALITY NOTICE: This transmission may contain confidential information protected by state or federal law. The information is intended only for use consistent with the state business discussed in this transmission. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents is strictly prohibited. If you have received this transmission in error, please notify the sender immediately to arrange for return, destruction or deletion of the transmission. Your cooperation is appreciated.

1 0