- Zope - Zope lists

Bug in sqlvar.py?
by Jeff K. Hoffman 14 Mar '99

14 Mar '99

Hello, everyone. I'm bustin' ass on my project for the outdoors group and ran into a problem with the #sqlvar command. At the top of the file, in the docstring, it says: For example, given the tag::  And, when I submit the query while leaving address2 blank I get: Invalid empty string value for address2 When reading the code, beginning on line 200 there is the else case which handles values of types other than int or float: else: v=str(v) if not v and t=='nb': raise ValueError, ( 'Invalid empty string value for <em>%s</em>' % name) v=md.getitem('sql_quote__',0)(v) #if find(v,"\'") >= 0: v=join(split(v,"\'"),"''") #v="'%s'" % v There is absolutely no check for the optional flag in this case as there are in the cases for int and float. Is this check supposed to be handled elsewhere in the code, and never make it here, or is this an oversight? I can patch it to fix the problem quite easily, but if this is not the preferred way of doing things I'd like to know (to avoid patching it every time a new Zope comes out.) I have two address lines, address1 and address2. I just want it to set address2 to null if the user does not fill it out. Is that too much to ask? :^) As I said, if I'm blatantly overlooking something, please let me know. If not, I'll be happy to submit a patch and/or report this in the collector. Thanks. Hope you all are having a good weekend! jkh

1 0

Structured text and lists
by Milos Prudek 13 Mar '99

13 Mar '99

Can I make ordered/unordered lists using structured text, without doublespacing lines? When I write single spaced lines: - one - two - three it's not rendered as list. And when I write doublespaced lines, it's rendered as doublespaced list... -- Milos Prudek

1 0

object modification date - how ?
by Andy Heath 13 Mar '99

13 Mar '99

I'm still a zope newbie Is there an easy way I can get a a modification date for an object (so I can do a "last modified on ...")? Andy -------------------------------------------------------------- Andy Heath, Senior Lecturer email: a.k.heath(a)shu.ac.uk o Sheffield Hallam University. Phone: +44 114 2534904 /\ Sheffield, England Fax: +44 114 2533161 () () --------------------------------------------------------------

2 1

Cool! Attribution!
by Tres Seaver 13 Mar '99

13 Mar '99

A quick plug for a "Powered by Zope" site I just saw: http://www.denarius.com/ -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

1 0

INSERT Syntax with Zope & ZPyGreSQLDA
by lstep＠mail.dotcom.fr 13 Mar '99

13 Mar '99

Hello, I'm trying to use PostGreSQL with Zope, but I'm having problems using the SQL INSERT method in Z methods which require parameters. For example, I make a Z SQL Method named 'foo'. In it: INSERT INTO messages VALUES (, 'blahblahblah', 'now', 'f') I write the name auteur in the 'arguments' form. Next I create a DTML document with: <form action="foo" method="GET"> Auteur: <input width="30" name="auteur" value=""><br> <input type="submit" name="SUBMIT" value="Envoyer"> <form> When submitting the form, it displays me a new page (generated by Zope) asking me again the auteur parameter, as if the auteur variable wasn't passed to the Z SQL method :-( Someone posted a mail recently with an example use of INSERT, where he put '(auteur)' after the 'INSERT INTO messages' text: INSERT INTO messages (auteur) ... When I try this, I get: Error, pg.error: server fatal error. Please report to your db administrator. SQL used: INSERT INTO messages (auteur) VALUES ('testing again', 'blahblahblah', 'now', 'f') Is there something specific to PostGreSQL ? (Using Zope 1.10.2, PostGreSQL 6.4.2, PyGreSQL-2.2, ZPyGreSQLDA 0.02) I looked in the Z SQL Method User's guide, but nothing is written about adding data to a DB :-( -- Luc Stepniewski <lstep(a)mail.dotcom.fr> http://www.planete.net/~rstep/pubkey.txt KeyID: 1024D/76A31F52 GnuPG: 819D 1F8E 7BE2 B80C AA2C 0473 CCED 48B6 76A3 1F52

2 1

User Profiles?
by Jeff K. Hoffman 13 Mar '99

13 Mar '99

I am working on a web site for a local outdoors group. They have about 1,000 members and are growing fast, but their web site needs help. I had lunch with their leader today, and strongly advocated the use of Zope to redo their entire web site. He loved my ideas, and gave me the go ahead on the site. Now, my first question (I'm sure I'll have many) to the group is: How do I create user profiles? Each user of the system needs to have specific information associated with them including: full name, address, telephone numbers, a picture (gif or jpeg, easily uploadable by the user), their interests, a history of the events they've sponsored and/or attended, a buddy list (basically just a collection of other member ids), and so on. I have downloaded the UserDb product, and figure I might be able to extend it to support the extra columns I require. However, a big part of me wants to keep as much of this in Zope as I can. I like the idea of the objectstore, and don't necessarily like having to fudge SQL tables every time I add or remove an attribute from the profiles (not that I will be doing that, necessarily). What do those with a higher Zope Zen Rating than I suggest in this situation? I'm also going to be making an Events Calendar, which is connected up with all the User information (who's running the event, who's signed up to attend, etc.). Is all of this something that Tabula would be good for? If so, who do I have to sleep with to get it? :^) I am willing to write up a case study, testimonial, contribute any code I write back to the community, etc., whatever is requested. I just want to do a good job for these guys, making myself and Zope look good in the process. HELP! *grin* Jeff K. Hoffman

2 1

RE: [Zope] User Profiles?
by Paul Everitt 13 Mar '99

13 Mar '99

Jeff wrote: > I am working on a web site for a local outdoors group. They have about > 1,000 members and are growing fast, but their web site needs > help. I had > lunch with their leader today, and strongly advocated the use > of Zope to > redo their entire web site. He loved my ideas, and gave me > the go ahead on > the site. Hot damn! > Now, my first question (I'm sure I'll have many) to the group > is: How do I > create user profiles? Each user of the system needs to have specific > information associated with them including: full name, > address, telephone > numbers, a picture (gif or jpeg, easily uploadable by the user), their > interests, a history of the events they've sponsored and/or > attended, a > buddy list (basically just a collection of other member ids), > and so on. > > I have downloaded the UserDb product, and figure I might be > able to extend > it to support the extra columns I require. However, a big > part of me wants > to keep as much of this in Zope as I can. I like the idea of the > objectstore, and don't necessarily like having to fudge SQL > tables every > time I add or remove an attribute from the profiles (not that > I will be > doing that, necessarily). Ahh, you're just buttering us up :^) You are, of course, completely correct. > What do those with a higher Zope Zen Rating than I suggest in this > situation? I'm also going to be making an Events Calendar, which is > connected up with all the User information (who's running the > event, who's > signed up to attend, etc.). Is all of this something that > Tabula would be > good for? If so, who do I have to sleep with to get it? :^) > > I am willing to write up a case study, testimonial, > contribute any code I > write back to the community, etc., whatever is requested. I > just want to > do a good job for these guys, making myself and Zope look good in the > process. I predict we'll have something like this called a Membership System, say, May 18th for a first cut. If my previous history of fibs, spinning, obfuscation, and downright lies makes you suspicious, or if you distrust my poor prognostication, I'd suggest that you take the user objects in UserFolder and turn them into extended DTML Documents, or perhaps even Folders. --Paul

1 0

RE: [Zope] the HTML UI - can I help?
by Paul Everitt 13 Mar '99

13 Mar '99

Andrew wrote: > I see a number of things that might help enhance the usability of the > zope UI, how do I go about submitting those possible changes > to the HTML > code ? I could mock up a page with HTML and explain how it works... That's a good idea. No, that's a fantastic idea. We have long known that we at Digital Creations aren't world beaters at clean interfaces. --Paul

1 0

RE: [Zope] extending dreamweaver into zope
by Paul Everitt 13 Mar '99

13 Mar '99

Andrew wrote: > I can see a number of things that DW will (I think) do to help out > Zope - but there is one item in the way - FTP support > There is no direct way for Dreamweaver to send pages back to Zope > without either writing to a filesystem via a LAN or by using FTP (no > webdav yet). Got it. > So my question is this - when will we get ftp support in > zope? (not just > alpha). Let's see, Amos will probably return to ZServer maybe week after next, beta1 might be a week or two after that. > I am looking at the dtml spec right now and thinking about building > drag-and-drop objects for DW that talk zope. > One thing I need is for someone on the zope team or elsewhere > to help me > test these so that I get the syntax correct. > Email me directly at andreww(a)netscape.com That's fantastic! Well there are lots of people on the list that are pretty good at DTML and would love to see DW integration. Obviously we here at DC would like to help you as well! --Paul

1 0

RE: [Zope] sequence of numbers
by Paul Everitt 13 Mar '99

13 Mar '99

Bill wrote: > What I want to do is given a limit number, iterate over a sequence of > DTML commands. This would be an obvious use for #in (which I'm using > elsewhere for other things) except I don't have a sequence - just the > number of items in the sequence, as it were. Here's a brute-force way to do it, as long as the list of items was short:   <br>  --Paul

1 0