- Zope - Zope lists

Re: [Zope] 'Enter query parameters'
by lstep＠mail.dotcom.fr 14 Mar '99

14 Mar '99

Hannu Krosing <hannu(a)trust.ee> writes: > > Auteur: <input width="30" name="auteur" value=""><br> > > why no type=text ? Oops forgot it. Well it worked without it :-) > This is definitely wrong ;( > > something like > INSERT INTO messages (auteur,title,bookdate,any_good) > VALUES > ('testing again', > 'blahblahblah', 'now', 'f') Ow you're right. But this hasn't changed anything, it still ask me for the parameters after clicking on submit :-( In the HTML form, I replaced the action with '<form action="add_message/manage_test" method="get">' where add_message is the Z SQL method. And it adds correctly the record to my Database, but displays 'This was not a query'. And, well, I don't think taht's the correct method to add records, by using the test method :-)) Is there anywhere an example of product adding some records to a database ? > might have worked. You may also mean current_date or current_time > instead of now or now() What's the difference between now and current_date / current_time I tried all of them, and they give exactly the same result (the good date :-) Thanks, Luc -- 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

fsimport HowTo
by Milos Prudek 14 Mar '99

14 Mar '99

Trying to use fsimport.py module, I get the following error: Sorry, an error occurred. Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 877, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 590, in publish (Info: /ppm/fsimport) File /usr/local/zope/lib/python/Products/ExternalMethod/ExternalMethod.py, line 254, in __call__ (Object: CopySource) (Info: ((<Folder instance at 0x8a74010>, '/web/srvs-sol/www.sol.cz/ppm/index.htm', form: fsdir: '/web/srvs-sol/www.sol.cz/ppm/index.htm' [environ info omitted for brevity] ), {}, (None,))) TypeError: read-only buffer, class I put fsimport.py into /usr/local/zope/Extensions/ (I had to create Extensions dir), and added fsimport external method to a directory 'ppm', then I pointed my browser to http://www.sol.cz/Zope/ppm/fsimport?fsdir=/web/srvs-sol/www.sol.cz/ppm/inde…, which probably is not the way to do it, is it? -- Milos Prudek

1 0

Re: [Zope] please interpret
by Tres Seaver 14 Mar '99

14 Mar '99

On Fri, 12 Mar 1999 13:03:08 -0500 Jeffrey P Shell wrote: > >From: julian(a)zereau.net > > > > "TypeError: read-only buffer, class" > > > > I keep getting this error, please can someone explain what typically > > causes it? > > This is a buglet in ExternalMethod where an exception has been raised and > caught by ExternalMethod, and EM is looking at the values of the traceback > for some special conditions. It's trying to do a string.lower() call on > one of the values that in Python1.4 was always a string, but in Python1.5.x > is an instance (in Python 1.5, standard exceptions became classes). This > has been fixed and will be in the next release. Could you post the patch, please? This error message hits me about five ways from Sunday. -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

2 1

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