[Zope] Windows NT: Changing default TCP port
Simple question (I presume): How do I change the Zope service under Windows NT to listen on port 80 (instead of 8080). Steve Smith ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Where to store my data?
Randall, You're crazy (or rather, you will be by the end of it...) Seriously though, I've spent 3 months developing a site using Zope, and just now is it starting to feel a bit more natural to use. Probably not knowing Python was a handicap. I chose the RDBMS approach to store posts, etc as I was familiar with SQL. I still don't think you can beat the search capabilities of a properly designed database, and Zope does make SQL integration straightforward. Zope has all the right characteristics for what you want to do, but it may send you 'round the twist making it happen! Good luck! Steve - Original Message - From: Randall Kern To: [EMAIL PROTECTED] Sent: Tuesday, November 14, 2000 7:00 AM Subject: [Zope] Where to store my data? I've just started playing with Zope again, and this time I'm going to spend enough time with it to actually decide if it's crazy or I am :) My project currently consists of a bunch of community "modules" written in PHP using MySQL as a data store. Each modules PHP code produces an XML page, by running a bunch of queries in the database, and performing some logic. These XML pages are then processed using XSLT, with a model very similar to Acquisition. I'm getting very tired of the poor language design inherent in PHP, and wanted to start using Python again. (Big reason for doing this work: In the current package, each module is only accessible from a hardcoded URL, such as /links for the Links module, etc. Many of my customers want to change the layout of their site, and in fact maybe have two Links modules, etc.) So far, sounds like Zope would be a great system for me. It would give my customers a good platform to customize their sites, and give me a good platform to build my modules with. Now, short of just doing it and then discovering what I did wrong, I'm hoping to get some advice from the Zope community on how to structure this system. This is a fairly large system, I host about 10 customers per box, serving about 4MM page views. 99% of the pages are dynamic, doing real-time database queries. Some of my first questions: -Is Zope a good choice for this kind of project? -Which is better: Store my content (Forum posts, Links, etc) in ZODB, or a MySQL database? -Build my Product (right term?) in DTML/ZClasses (seems easier for my users to customize?) or build it in Python? -Can I (easily) build this system in 4 layers: Content -- actual low-level storage, rarely customized Logic/Object Representation -- layer used to interact with the content, also rarely customized, although does have configuration options XML (page contents) -- every URL should result in an XML document, containing all the information that will be presented on that page. Written in DTML? XSLT (page rendering) -- the XML documents must be transformed into HTML/etc. These transformations, like the page contents should be inherited; excuse me, acquired. -Simple things should be simple, Complex things should be possible. -- My users should be able to plop a Links module into their site, edit the Properties for that Object, and it works. If they want to change the way Links are categorized, they should be able to, although it'll take a while longer :) Thanks for your Zen, -Randy
RE: [Zope] acl_users API
I must be blind... I've been through the whole book (I think), and can't find a shred of info on manipulating acl_users with DTML. In one of the chapters it leads with the tantalizing phrase "we'll see how to give users the ability to change their own passwords later", but the trail goes cold. I'm sure there is a way... Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Anderson Sent: Thursday, 2 November 2000 2:56 To: '[EMAIL PROTECTED]' Subject: Re: [Zope] acl_users API Harris Peter wrote: Hi I have given up trying to manipulate acl_users from DTML for now - I'm sure it's possible because here and there on this list and on the Zope site I see hints that it can be done. However, I can't find (for example) a HOWTO anywhere that describes the API of acl_users and what you can do with it. Try: http://www.zope.org/Members/michel/ZB/ -- E PLURIBUS LINUX ___ Zope maillist - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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 )
RE: [Zope] Sendmail examples
Hi Tony, Thanks for taking the time to answer. The "MailHost" object seems to be the key. I tried going around it (using the SMTPHost attribute, from memory), without much luck. Also learnt that one needs at least modest knowledge of SMTP syntax when forming the option lines! Thanks again, Steve -Original Message- From: Tony McDonald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 24 October 2000 8:35 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [Zope] Sendmail examples At 10:01 pm +1000 22/1/01, steve smith wrote: Anyone have any good, real-world examples using DTML-Sendmail tags? Would especially appreciate examples integrating SQL queries. Ta! Steve What, you mean including ones that send mail into the future? :) (couldn't resist). Assuming you've set up a MailHost object called 'MailHost' Set up a FORM with variables: recipient, name and comments and make the ACTION URL the following piece of DTML (with appropriate sugar around it) !--#sendmail mailhost="MailHost"-- To: Feedback Recipient !--#var recipient-- From: Zope Feedback Form zope_form@thoth Subject: Feedback from the web Feedback from : !--#var name-- Comments: !--#var comments-- !--#/sendmail-- hth tone -- Dr Tony McDonald, FMCC, Networked Learning Environments Project http://nle.ncl.ac.uk/ The Medical School, Newcastle University Tel: +44 191 222 5116 A Zope list for UK HE/FE http://www.fmcc.org.uk/mailman/listinfo/zope ___ Zope maillist - [EMAIL PROTECTED] 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] Sendmail examples
Anyone have any good, real-world examples using DTML-Sendmail tags? Would especially appreciate examples integrating SQL queries. Ta! Steve ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] ZSQL Method AUTHENTICATED_USER
I have an approach that works for me, but it may be a bit awkward. I have a SQL method (dbGetUserID) which takes AUTHENTICATED_USER as an argument and finds the value from the "userid" field in the database: select userid from users where shortname = dtml-sqlvar AUTHENTICATED_USER type=nb When I need to perform database ops on the user, I just call this method and use the resulting id, eg, insert into sometable (userid, otherfield) values (dtml-in dbGetUserIDdtml-sqlvar userid type=int/dtml-in, dtml-sqlvar sequence-item type=int) I have AUTHENTICATED_USER in the parameter list for this SQL method as well, though it may not need to be... Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jon Prettyman Sent: Thursday, 19 October 2000 8:18 To: [EMAIL PROTECTED] Subject: Re: [Zope] ZSQL Method AUTHENTICATED_USER I'm pretty sure that all variables have to be passed in explicitly with SQLMethods. Namespaces are not passed in. Try specifying username as an argument in the ZSQLMethods edit form and pass it in like this: dtml-in expr= "lookup_by_username(username=REQUEST.AUTHENTICATED_USER.getUserName()" (Untested) -jon Aaron Straup Cope [EMAIL PROTECTED] writes: Hi, I'm trying to perform a simple MySQL lookup based on the AUTHENTICATED_USER. When I test the ZSQL method from the management interface, everything works fine. However, when I try to call the method from a DTML document, [it] returns nothing. Is this a namespace issue? I'm stumped and hoping that I'm not staring right past the problem. Can anyone point out what it is I am doing wrong? Thanks, a) DTML Document : foo dtml-with people dtml-in lookup_by_username dtml-var "username" /dtml-in /dtml-with b) ZSQL Method : people.lookup_by_username select * from people where username = "dtml-var "REQUEST.AUTHENTICATED_USER.getUserName()"" ___ Zope maillist - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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] Passing lists to zsql methods
I have a form comprising two selection lists, each supporting multiple selection. I want the inputs to become parameters to a zsql method. I find the input works if the user selects at least one item from each list, but fails with a 'bad object id' message if either list is left unselected. I have tried providing a default list value, no luck. Any ideas out there? The form looks like: dtml-var standard_html_header pfont face="Arial"Use this form to specify the parameters for your query or submission pAll fields are optional pMultiple selection is supported - hold down the CONTROL key/font /p FORM action="dtSubmitRumour" SELECT name="Operators:list" multiple dtml-in dbRetrieveAllOperators OPTION VALUE='dtml-var OperatorID' dtml-var FullName null="None in particular" /OPTION /dtml-in /SELECT SELECT name="Classes:list" multiple dtml-in dbRetrieveAllClasses OPTION VALUE='dtml-var OperatorClassID' dtml-var "FullName + OperatorClass + ' Class'" /OPTION /dtml-in /SELECT input type="submit" value="Submit" name="B1"/p /FORM and the zsql method reads: use thetable BEGIN transaction INSERT INTO rumours (Description) VALUES (dtml-sqlvar Description type=nb optional) DECLARE @rumourid int SELECT @rumourid = MAX(rumourid) FROM rumours COMMIT dtml-if Operators dtml-in Operators INSERT INTO roperators(rumourid, OperatorID) VALUES (@rumourid, dtml-sqlvar sequence-item type=int) /dtml-in /dtml-if dtml-if Classes dtml-in Classes INSERT INTO rclasses(rumourid, ClassID) VALUES (@rumourid, dtml-sqlvar sequence-item type=int) /dtml-in /dtml-if ___ Zope maillist - [EMAIL PROTECTED] 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 )
