- Zope - Zope lists

RE: [Zope] Sql questions.
by CHOY,CHARLENE (HP-Boise,ex1) 07 Aug '01

07 Aug '01

Thanks Eric and Jim. I reread that section and found a better way to implement my sql. Have a nice day!^_^ -Charlene -----Original Message----- From: Eric Walstad [mailto:eric@walstads.net] Sent: Tuesday, August 07, 2001 3:13 PM To: CHOY,CHARLENE (HP-Boise,ex1); Zope List (E-mail) Subject: RE: [Zope] Sql questions. Hi Charlene, Have you read the section of the Zope book regarding Dynamic SQL Queries? In particular, look for info on the "sqlgroup" tag. ( http://www.zope.org/Members/michel/ZB/RelationalDatabases.dtml ) and about 2/3 down the page you will see a heading that reads "Creating Complex Queries with the Sqlgroup Tag" If you need more detailed help, it would be helpful for us to see the SQL you are using now. Eric. > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of > CHOY,CHARLENE (HP-Boise,ex1) > Sent: Tuesday, August 07, 2001 1:54 PM > To: Zope List (E-mail) > Subject: [Zope] Sql questions. > > > Hi, > The following is my problem. I have created a search form to > look up some > data from a database. The result of the search needs to be able to return > the searched data in certain order. How do I set condition in the sql > method so that it will return the object that I want and also specific > sorting_method that the user had chosen in the form. > I have attempted to solve this problem. I have created two sql methods > but both of them perform two differenct tasks. One of them is able to > return the searched data that I want, but the data are not in order. The > second sql will return correct order, but it includes some other > serch data > that I don't want. Does anyone know to combine both of them so that the > users can get the data that they are looking for in the sorting > method that > they have chosen? > I would also like to know is there anyway that i can set some > if/elif/else > condition in the dtml-sql? If so how can I do it. > > -Charlene > > _______________________________________________ > 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 )

1 0

Problems with Zope 2.4.0 and OpenBSD 2.8
by Pat Ritchie 07 Aug '01

07 Aug '01

Hi, I'm having all sorts of problems getting Zope running on my i386 OpenBSD box. I am using python 2.1.1 compiled with --with-threads. The first problem I had was compiling Zope, I got this error: make: don't know how to make ././src/Splitter.c. Stop I read the docs (doc/FAQ.txt) and It said for some BSD systems you need to use make -k, I made this change and it compiled. Once compiled I edited z2.py to use port 80 (8080 is blocked by my firewall) and then ran start. It seems to start up and run fine but when I go to myserver.com/manage it asks me for my name and password and then stalls loading the page. Log file output: B 10064236 2001-08-07T21:09:40 GET /manage I 10064236 2001-08-07T21:09:40 0 A 10064236 2001-08-07T21:09:40 200 1106 E 10064236 2001-08-07T21:09:40 B 10064108 2001-08-07T21:09:41 GET /manage_top_frame I 10064108 2001-08-07T21:09:41 0 A 10064108 2001-08-07T21:09:41 200 1404 E 10064108 2001-08-07T21:09:41 B 10065740 2001-08-07T21:09:41 GET /manage_workspace I 10065740 2001-08-07T21:09:41 0 A 10065740 2001-08-07T21:09:41 302 421 E 10065740 2001-08-07T21:09:41 B 10066220 2001-08-07T21:09:41 GET /manage_menu I 10066220 2001-08-07T21:09:41 0 A 10066220 2001-08-07T21:09:42 200 2773 B 10065740 2001-08-07T21:09:42 GET /p_/zopelogo_jpg I 10065740 2001-08-07T21:09:42 0 E 10066220 2001-08-07T21:09:42 A 10065740 2001-08-07T21:09:42 200 3090 E 10065740 2001-08-07T21:09:42 B 10065740 2001-08-07T21:09:42 GET /manage_page_style.css I 10065740 2001-08-07T21:09:42 0 A 10065740 2001-08-07T21:09:42 200 2894 E 10065740 2001-08-07T21:09:42 B 10067788 2001-08-07T21:09:42 GET /manage_main I 10067788 2001-08-07T21:09:42 0 This could be related to the original compiling problem as the -k flag tells make to "Continue processing after errors are encountered, but only on those targets that do not depend on the target whose creation caused the error" ... In other words I might now be missing an essential bit of Zope? Should this message be sent to the Zope-dev list as well? Thanks, Patrick

1 0

Building a page from multiple paramatised queries
by Giles Chamberlin 07 Aug '01

07 Aug '01

I'm a zope novice so I'm probably missing something obvious. My intent is to build a web page from the results of two queries, each of which are paramatised by the same value. I've got a single query working fine: FeatureDetailQuery has a parameter ID and SQL: select * from Feature where <dtml-sqltest Id op=eq type=int> FeatureDetail is a simple web page: <dtml-var standard_html_header> <h1><dtml-var Name></h1> <dtml-var standard_html_footer> and I bind the two together by referencing them with the a href = FeatureDetailQuery/Id/<dtml-var Id>/FeatureDetail All's well. My problem is that I want to add the output of another query, also parametised by Id to the same web page and I'm stumped as to how to go about it. Any suggestions? Giles Chamberlin

2 1

Sql questions.
by CHOY,CHARLENE (HP-Boise,ex1) 07 Aug '01

07 Aug '01

Hi, The following is my problem. I have created a search form to look up some data from a database. The result of the search needs to be able to return the searched data in certain order. How do I set condition in the sql method so that it will return the object that I want and also specific sorting_method that the user had chosen in the form. I have attempted to solve this problem. I have created two sql methods but both of them perform two differenct tasks. One of them is able to return the searched data that I want, but the data are not in order. The second sql will return correct order, but it includes some other serch data that I don't want. Does anyone know to combine both of them so that the users can get the data that they are looking for in the sorting method that they have chosen? I would also like to know is there anyway that i can set some if/elif/else condition in the dtml-sql? If so how can I do it. -Charlene

2 1

Regarding Mysql Query
by sudhakar 07 Aug '01

07 Aug '01

hi guys, i am very new to zope . i executed a query that will print 25 column. i don't want to hardcode the column name.i am getting the column name by below python script test.py rec = context.DbQuery1() print "names: ", rec.names(), "\n" return rec.names() using the column name i want to print the corresponding data. <dtml-in test.py> <dtml-in DbQuery1 size=10 start=query_start> <dtml-let names="_.getitem('sequence-item')"> <dtml-var names> </dtml-let> </dtml-in> </dtml-in> but it's printing the object. <r instance at 02FF5E50> <r instance at 02FF5730> <r instance at 02FF5200> <r instance at 02FF59A0> <r instance at 02FF54F0> <r instance at 02FF5B60> <r instance at 02FF5180> <r instance at 02FF64A0> <r instance at 02FF68B0> <r instance at 02FF6500> can any one help me . regards, S.Sudhakar Sys Admin, Progammer Mindscape Computing (P) Ltd., Bangalore

3 2

ScriptSearch.com: Link Added!
by gwinfield＠internet.com 07 Aug '01

07 Aug '01

Hello Digital Creations, Inc.: Thank you for visiting ScriptSearch.com! We've added your resource listing in our directory like this: Resource ID : 3009 Title : Zope URL : http://www.zope.org Summary : Web application framework Description : Zope is a framework for building web applications. A web application is a computer program that users access with a web browser over the Internet. You can also think of a web application as a dynamic web site that provides not only static information to users but lets them use dynamic tools to work with an application. Version : Price : ZPL Download URL : Editor's Pick: No Contact Name : Digital Creations, Inc. Contact Email: zope(a)zope.org And, A few other relevant URLs to keep close by. . . . Your resource is listed under: http://www.scriptsearch.com/Python/Scripts_and_Programs/Content_Management/ Your resource's details page is at: http://www.scriptsearch.com/details/3009.html Modify your resource listing by going to: http://www.scriptsearch.com/cgi-bin/modify.cgi?ID=3009&email=zope@zope.org We encourage you to place a rating form for your resource on your site. Just follow the steps at: http://www.scriptsearch.com/cgi-bin/get_rated.cgi?ID=3009 Please also add a link back to ScriptSearch from your site, like this: <A HREF="http://www.scriptsearch.com">ScriptSearch.com</A> Sincerely, Ronnie T. Moore ScriptSearch.com Note: Replies to this email will bounce. Email us at http://www.scriptsearch.com/cgi-bin/contact.cgi ) ScriptSearch Admin only: If mail bounces, delete resource: http://www.scriptsearch.com/cgi-bin/admin/admin.cgi?db=links&delete_records…

1 0

RE: [Zope] Pluggable Brains
by Montagne, Michael 07 Aug '01

07 Aug '01

Thank you my friend. It works now. -mjm -----Original Message----- From: J. Cone [mailto:jcone@g8labs.com] Sent: Tuesday, August 07, 2001 12:08 PM To: Montagne, Michael; 'zope(a)zope.org' Subject: Re: [Zope] Pluggable Brains Suggest you try: python Employee.py in the extensions directory and see if you get better information cheaper. At 11:54 07/08/01 -0700, Montagne, Michael wrote: >I'm trying to create a Pluggable Brain so I can incorporate various >functions involving employees from my ZSQL Method. > <snip> >This is the Employee.py file in the Extensions folder: >"""Employee class for extra innformation""" >class Employee: > def fullName(self): > """Returns full name for employee using nickname if any""" > if self.nickname: > return self.nickname + ' ' + self.emplastn > else: > return self.empfirstn + ' ' + self.emplastn <snip>

1 0

Pluggable Brains
by Montagne, Michael 07 Aug '01

07 Aug '01

I'm trying to create a Pluggable Brain so I can incorporate various functions involving employees from my ZSQL Method. This is the SQL code: SELECT StaffId, empfirstn, emplastn, nickname, extension, initials FROM tblHRPersonnel INNER JOIN tblS4Emp ON tblHRPersonnel.empidno = tblS4Emp.empidno WHERE tblS4Emp.empactive='Y' AND tblHRPersonnel.FilterOutofWeb=False ORDER BY tblS4Emp.emplastn; This is the Employee.py file in the Extensions folder: """Employee class for extra innformation""" class Employee: def fullName(self): """Returns full name for employee using nickname if any""" if self.nickname: return self.nickname + ' ' + self.emplastn else: return self.empfirstn + ' ' + self.emplastn This is the error: Traceback (innermost last): File e:\Program Files\Zope\lib\python\ZPublisher\Publish.py, line 223, in publish_module File e:\Program Files\Zope\lib\python\ZPublisher\Publish.py, line 187, in publish File e:\Program Files\Zope\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: ActiveStaff) File e:\Program Files\Zope\lib\python\ZPublisher\Publish.py, line 171, in publish File e:\Program Files\Zope\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_advanced) File e:\Program Files\Zope\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: manage_advanced) File E:\Program Files\zope\lib\python\Shared\DC\ZRDB\DA.py, line 299, in manage_advanced (Object: ActiveStaff) File E:\Program Files\zope\lib\python\App\Extensions.py, line 238, in getBrain File E:\Program Files\zope\lib\python\App\Extensions.py, line 217, in getObject (Info: ('e:\\Program Files\\Zope\\Extensions\\Employee.py', 'Employee')) SyntaxError: (see above)

2 1

ZCatalog automatic indexing
by Priya Ramkumar 07 Aug '01

07 Aug '01

Hi WIth the ZCatalog, I find that the Catalog does not get updated automatically when new files are added. Can anyone please tell me how one could automate the updation of the Zcatalog? I am using Zope2.3.3 & CMF1.1. Thanks for any suggestions. Regards, Priya.

2 1

Photo information
by Chris Muldrow 07 Aug '01

07 Aug '01

I'm trying to extract the IPTC/NAA caption information from JPEGs stored by Photoshop. I've noticed the IPTC plugin for the Python Imaging Library, but can't figure out how it works and can't seem to find any helpful docs on it. Two questions: Anyone know how to do this, and is it best once I've figure out that part of the puzzle to access it through an external method? Or is Zope gonna strip out the information when the image is made into an image object? Thanks! -- Chris Muldrow muldrow(a)mac.com cmuldrow(a)fredeicksburg.com

2 1