- Zope - Zope lists

Re: [Zope] ZSQL Advice needed - no results, one match, multiple matches
by Dieter Maurer 23 Mar '01

23 Mar '01

sdduncan(a)indiana.edu writes: > > I would like to query a mysql database .... > .... > If there are no matches I want to print out that fact > IF there is one match I want to display the results of an sql query > based on the personID You will find an example in URL:http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html It is Example 3.14 in section DTML -> Commands -> let. Dieter

1 0

Re: [Zope] Test if document does exist
by Dieter Maurer 23 Mar '01

23 Mar '01

Marc Fischer writes: > How can I test with an dtml-if, if a special document does exist? You cannot test if a special document exists but you can test, if a name is defined in a namespace (this may be a document, property or just a name bound to a volatile object): <dtml-if "_.has_key(name_of_your_object)"> .... </dtml-if> Dieter

1 0

tino's <dtml-in> improvements
by Joel Burton 23 Mar '01

23 Mar '01

At http://www.zope.org/Members/tino/in_tag_patch, member tino has a patched version of dtml-in that solves two problems: * having to use ugly syntax for python expressions using sequence vars such as <dtml-if "_['sequence-item'] > 40">. The patch allows <dtml-if "sequence_item > 40"> * allowing you to set a prefix="books" attrib to <dtml-in>, so that instead of sequence-item, you can reference books-item, or books-next, etc. This is nice syntactic sugar, but especially nice for nested <dtml-in> tags, allowing you to easily refer to seq. variables in the outer dtml-loop, while in the inner loop. However, the product isn't updated perfectly for 2.3--the sequence variables for '-number' aren't working (the less helpful '-index' ones are). It seems like patches like this need to get into the Zope core if they're going to make it in the long run. Has anyone updated this for 2.3 -number vars? Can we get consensus that this should join the Zope core? -- Joel Burton <jburton(a)scw.org> Director of Information Systems, Support Center of Washington

8 10

User_Management - Two Folders in different branches
by Carl Blesius 23 Mar '01

23 Mar '01

I have a basic Problem with ZOPE USER MANAGEMENT Roles on our site root: Anonymous User Author Editor Manager Owner Okay... lets say I have one folder /users/John_Doe/ with an acl_users folder in it with one user (John_Doe). After John_Doe knows his way around Zope well enough I am going to let him take over a branch of our website e.g. /clinics/pathology/ How do I grant him access to that area of the site without having to create another acl_users in that folder? (A single password and account per user would be nice, as well as a single password_change mechanism for all users) Would a the LDAPLoginAdapter solve my problems (does it allow one account access to specific folders in different branches of a site)? Carl

1 0

Re: ZCatalog page...
by Chris McDonough 23 Mar '01

23 Mar '01

Press the "Help" button at the top right of any Zope management screen page. Look for "API Documentation" within the help index screen. ----- Original Message ----- From: <afterz(a)zipmail.com> To: "Chris McDonough" <chrism(a)digicool.com> Sent: Friday, March 23, 2001 12:39 PM Subject: Re: ZCatalog page... > > I`m sorry my ignorance, but where can I find it? > > --- In zope@y..., "Chris McDonough" <chrism@d...> wrote: > > Take a look in the help system under API Documentation for both > ZCatalog and > > dtml-in. > > > > ----- Original Message ----- > > From: "After Dark" <afterz@z...> > > To: <zope@z...> > > Sent: Friday, March 23, 2001 10:02 AM > > Subject: [Zope] ZCatalog page... > > > > > > > > > > Hi, I`m developing a search for a site and I`m using > > > ZCatalog. > > > I made a basic search, but now I don`t know how to get the > > > number of rows resulted from the search, and how to make it > > > show the results by pages. > > > Is there a manual reference that show me all the functions > > > of ZCatalog, and/or a page/source that show me how to do all > > > that? > > > > > > I`d like something like zope.org`s search, but in there I > > > just got a piece of code, and didn`t helped much. > > > > > > Thanks. > > > > > > -- > > > --Ricardo Kohler > > > Costa > > > ________________________________________________ > > > Don't E-Mail, ZipMail! http://www.zipmail.com/ > > > > > > > > > _______________________________________________ > > > Zope maillist - Zope@z... > > > 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 maillist - Zope@z... > > 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

RE: [Zope] can't install PoPy
by Farrell, Troy 23 Mar '01

23 Mar '01

On debian, my source install needed includes from 2 locations, so I did this: ./configure --with-postgres-libraries=/usr/local/pgsql/lib --with-postgres-includes="/usr/local/pgsql/include -I/usr/src/postgresql-7.0.3-src/src/include/" Troy -----Original Message----- From: Bak @ kedai [mailto:kedai@kedai.com.my] Sent: Friday, March 23, 2001 10:46 AM To: Damir Bartakovic; zope(a)zope.org Subject: Re: [Zope] can't install PoPy -----Original Message----- From: Damir Bartakovic <damir(a)stud.fbi.fh-darmstadt.de> To: zope(a)zope.org <zope(a)zope.org> Date: Friday, March 23, 2001 8:43 PM Subject: [Zope] can't install PoPy >on RedHat 7.0 >Postgres 7.0.2 in /usr/postgres (from the source .gz) >Zope 2.3.0 in /home/zope (from the source .gz) > >./configure --with-python=/home/zope/bin/python --with-postgres-libraries=/ u >sr/postgres/lib --with-post >gres-includes=/usr/postgres/include > when i installed PoPy on my rh 7, with postgres & postgresql-devel from rpm, i use with-libs=/usr/lib with-includes=/usr/include/pgsql >and some other combinations without effect. > >I am a bit confused, because I can't remember a problem on my previous >installation on RedHat 6.2. >Do I have to build the /usr/lib/python1.5/config/Makefile somehow? >why are the PostgreSQL Libraries not found? > >Any clues? >Thanks in advance! > > >_______________________________________________ >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 ) > _______________________________________________ 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

Re: [Zope] ZCatalog page...
by afterz＠zipmail.com 23 Mar '01

23 Mar '01

Ok, thanks. And where can I find it? Somebody has an example of formating date and time for bobobase_modification_time? Bye. --- In zope@y..., "Chris McDonough" <chrism@d...> wrote: Take a look in the help system under API Documentation for both ZCatalog and dtml-in. ----- Original Message ----- From: "After Dark" <afterz@z...> To: <zope@z...> Sent: Friday, March 23, 2001 10:02 AM Subject: [Zope] ZCatalog page... > > Hi, I`m developing a search for a site and I`m using > ZCatalog. > I made a basic search, but now I don`t know how to get the > number of rows resulted from the search, and how to make it > show the results by pages. > Is there a manual reference that show me all the functions > of ZCatalog, and/or a page/source that show me how to do all > that? > > I`d like something like zope.org`s search, but in there I > just got a piece of code, and didn`t helped much. > > Thanks. > > -- > --Ricardo Kohler > Costa > ________________________________________________ > Don't E-Mail, ZipMail! http://www.zipmail.com/ > > > _______________________________________________ > Zope maillist - Zope@z... > 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 maillist - Zope@z... 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 ) --- End forwarded message ---

1 0

Re: Mysql on Windows will not connect [SOLVED]
by Aaron Held 23 Mar '01

23 Mar '01

My mistake, the last email was incorrect. I downloaded MySQL-python-0.3.4.tar.gz but actually installed the windows version MySQL-python-0.3.3-win32-2.zip which is not supported by ZMySQLDA-2.0.5.tar.gz So I uninstalled ZMySQLDA-2.0.5 and installed ZMySQLDA-2.0.4.tar.gz I can query the database and everybody is happy. Thanks anyway, -Aaron ----- Original Message ----- From: "Aaron Held" <aaron(a)metrony.com> To: <zope(a)zope.org> Sent: Friday, March 23, 2001 12:02 PM Subject: Mysql on Windows will not connect > I am trying to setup a Z MySQL Database Connection to hit a local mysql server and keep getting errors. > > When I try to login with the following connection string: > > varex varex varex > > I get this error > Error Type: OperationalError > Error Value: (1045, "Access denied for user: 'varex@localhost' (Using password: YES)") > > If I try > > varex(a)10.4.4.78 varex varex > > I get this error > > Error Type: AttributeError > Error Value: server_capabilities > > I can login either way via the mysql command line. > > I can also use the python-mysql adapter from the pyton runtime that came with Zope > > D:\Python_Mysql\examples>d:\website\bin\python deirdre.py > Color number 1L is red > Color number 2L is blue > Color number 3L is yellow > > I do not know how to test teh Zope Mysql DA outside of Zope. > > Anyway I am running > Win98 > Zope 2.3.0 (from Zope-2.3.0-win32-x86.exe) > mysql on windows 3.23.28-gamma-debug > ZMySQLDA-2.0.5.tar.gz > MySQL-python-0.3.4.tar.gz > > Any pointers on what to do next? > > -Aaron > =================================================================== > As Isaac Newton would say now: > If I see further than others, it is because I stand on > the shoulders of giants too dumb to patent their discoveries. > (Gregory Palast, http://www.observer.co.uk/ ) > >

1 0

ZCatalog page...
by After Dark 23 Mar '01

23 Mar '01

Hi, I`m developing a search for a site and I`m using ZCatalog. I made a basic search, but now I don`t know how to get the number of rows resulted from the search, and how to make it show the results by pages. Is there a manual reference that show me all the functions of ZCatalog, and/or a page/source that show me how to do all that? I`d like something like zope.org`s search, but in there I just got a piece of code, and didn`t helped much. Thanks. -- --Ricardo Kohler Costa ________________________________________________ Don't E-Mail, ZipMail! http://www.zipmail.com/

2 1

Mysql on Windows will not connect
by Aaron Held 23 Mar '01

23 Mar '01

I am trying to setup a Z MySQL Database Connection to hit a local mysql server and keep getting errors. When I try to login with the following connection string: varex varex varex I get this error Error Type: OperationalError Error Value: (1045, "Access denied for user: 'varex@localhost' (Using password: YES)") If I try varex(a)10.4.4.78 varex varex I get this error Error Type: AttributeError Error Value: server_capabilities I can login either way via the mysql command line. I can also use the python-mysql adapter from the pyton runtime that came with Zope D:\Python_Mysql\examples>d:\website\bin\python deirdre.py Color number 1L is red Color number 2L is blue Color number 3L is yellow I do not know how to test teh Zope Mysql DA outside of Zope. Anyway I am running Win98 Zope 2.3.0 (from Zope-2.3.0-win32-x86.exe) mysql on windows 3.23.28-gamma-debug ZMySQLDA-2.0.5.tar.gz MySQL-python-0.3.4.tar.gz Any pointers on what to do next? -Aaron =================================================================== As Isaac Newton would say now: If I see further than others, it is because I stand on the shoulders of giants too dumb to patent their discoveries. (Gregory Palast, http://www.observer.co.uk/ )

1 0