[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 )
[Zope] Passing paramaters for form processing
How do I set some parameters for use in a form processing method? I have a HTML "FORM" tag referencing a DTML method name, and I want that method to have visibilty of some variables from the calling methods space. I've tried passing them with the url (eg, "ACTION=/someurl?fred=") and by using REQUEST.set syntax in the calling method. Neither seems to result in the variable being visible to the form processing method. Any ideas? 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] 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 with variables: recipient, name and comments and make the ACTION URL the following piece of DTML (with appropriate sugar around it) To: Feedback Recipient <> From: Zope Feedback Form Subject: Feedback from the web Feedback from : Comments: 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 = 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 (, ) 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: (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 > > > > > > > > b) ZSQL Method : people.lookup_by_username > > select * from people where username = " "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] SQL cursor error
Anyone know what this means? Error Type: sql.error Error Value: ('24000', 0, '[Microsoft][ODBC SQL Server Driver]Invalid cursor state' I get this when I try to submit a form which passes control to a dtml method. that method in turn makes a dtml-call to another, which calls a SQL method. Regards 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 )
[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: Use this form to specify the parameters for your query or submission All fields are optional Multiple selection is supported - hold down the CONTROL key and the zsql method reads: use thetable BEGIN transaction INSERT INTO rumours (Description) VALUES () DECLARE @rumourid int SELECT @rumourid = MAX(rumourid) FROM rumours COMMIT INSERT INTO roperators(rumourid, OperatorID) VALUES (@rumourid, ) INSERT INTO rclasses(rumourid, ClassID) VALUES (@rumourid, ) ___ 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] Authentication problem when accessing ZSQL method
Hi, I am experiencing great frustration when trying to implement a drop-down list based upon one of the how-tos I found on the Zope site. Whenever I try to 'view' the DTML method which references the ZSQL method, I am prompted to authenticate by my browser. I can't see anything in the security attributes for the SQL method which requires authentication, and I can 'test' the ZSQL method succesfully without requiring authentication. I have tried providing my user credentials (ie, to match the one and only user defined in the 'acl-users' list', but that fails. Where should I start looking for the answer? Regards 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 )