June 2000 - Zope - Zope lists

neted dtml-in and ZSQL methods
by jpenny＠universal-fasteners.com 15 Jun '00

15 Jun '00

Suppose, you have a database, items, that has fields product and scheme. You are processing a form that has field old_product and new_product. You have a ZSQL method, get_scheme, with parameter old_product and body select * from items where product = <dtml-sqlvar old_product type=string>. You also have a ZSQL method, new_scheme, with parameter new_product and scheme. Observation: <dtml-in get_scheme> <dtml-call new_scheme> </dtml-in> fails, with message Zope Error Zope has encountered an error while publishing this resource. Error Type: NameError Error Value: scheme Troubleshooting Suggestions This resource may be trying to reference a nonexistent object or variable scheme. The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. even though <dtml-in get_scheme> <dtml-var "scheme"> </dtml-in> prints the expected value. Why? Jim Penny

1 0

left(string, n) equivalent (newbie q.)
by joel grimes 15 Jun '00

15 Jun '00

Pardon my ignorance, I'm coming from a VB/Access background. I need to find an equivalent to using left(string, 4) in a zope SQL method's select query. My SQL book says I can use SUBSTRING(string, 1, 4) in a query but no luck. I'm connecting to an Access database. btw - this mail list ROCKS! I've never waited more than 10 minutes for a response. Thanks ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

3 2

virtual hosts with ZServer
by Alex Gould 15 Jun '00

15 Jun '00

My apologies if this question has been answered before, but I couldn't figure it out from available documentation or list archives. I run a server for some student groups off a machine in my dorm and I'm teaching myself Zope (slowly). I deal with the dynamic IP address by using several *.penguinpowered.com domains. I would like to set up one or more virtual hosts such that http://host1.penguinpowered.com/ points to some folder in the Zope database. It seems this is possible using Set Access Rule and SiteRoot objects, but how? Any help is appreciated. I am now using plain zserver 2.1.6. -------------- Building highways to reduce traffic is like loosening your belt to reduce obesity.

4 6

Catalog Aware ZClass
by Scott Burton 15 Jun '00

15 Jun '00

Hello fellow Zopists, I want to create a catalog aware Zclass. I would like to include some specific indexable metadata when creating an instance of that object. So when I add an instance of that object it asks me for some information that gets indexed by ZCatalog to be searched later on. I have tried following the instructions given here: http://www.zope.org/Members/AlexR/CatalogAware But I noticed there is some information which may be outdated. It also suggests having to Patch CatalogAwareness.py I am not sure if this is still required? Or, where do I start? TIA! Scott

1 0

RE: [Zope] Version Paradox
by Baker, Dennis [sjmr] 15 Jun '00

15 Jun '00

Actually, I tried this first and it didn't work. not certain why. However your original suggestion of going into the version manager in control panel did the trick. Thanks for the suggestion I'm up and running again !! > -----Original Message----- > From: Dan Rusch [mailto:drusch@globalcrossing.com] > Sent: Thursday, June 15, 2000 12:30 PM > To: Baker, Dennis [sjmr] > Subject: Re: [Zope] Version Paradox > > > Dennis, > > Don't fret I just replicated you paradox and you can fix the > problem. I just > have to remember what I did, please bear with me. > > I created a version in a folder. > I entered the version > I then went to undo (while still in the version) and undid the version > > wham I'm stuck in a non-existant version > > I logged out of zope > I logged in as the superuser dude > I went to the folder > I recreated the same version (same name etc) > I went to the control panel > I went to Version Management > I disgard the version > > wham I'm unstuck > > Let me know if this helped.... > > DR > > > > > "Baker, Dennis [sjmr]" wrote: > > > No luck, Maybe I'm describing my problem wrong, When I go > to manage Zope > > The header at the top says " > > Folder at / * (/Developement%20Site) > > ^ (This is the version Symbol) > > > > It doesn't Say that I am working in a version otherwise. > Then if I attempt > > to create a new version I get the following error: > > > > Error Type: VersionLockError > > Error Value: ("'\\000\\000\\000\\000\\000\\000\\000\\002'", > > '/Developement%20Site') > > > > I can create a version in a subfolder, and subfolders > don't have the > > "Folder at" stuff all messed up. Unfortunately this is my > production server > > too, not my testing server. > > > > -----Original Message----- > > From: Cornelis J. de Brabander [mailto:brabander@fsw.leidenuniv.nl] > > Sent: Thursday, June 15, 2000 12:14 AM > > To: Baker, Dennis [sjmr]; zope(a)zope.org > > Subject: Re: [Zope] Version Paradox > > > > >I've inadvertently created a version paradox. I created a > version and > > >joined it, then I realized that I did a stupid naming > mistake I tried to > > >UNDO the creation of the version. It allowed me to undo > the creation of > > the > > >version, however I was in the version at the time, and > now I am stuck in > > >the version and cannot get out. I cannot create a version > of the same name > > >and delete it either. I am stuck. HELP !! > > > > > >How can I exit a version that doesn't exist? > > > > > I believe that versions are based on cookies and that > removing the culprit > > will unlock your paradox > > > > cb > > > > _______________________________________________ > > 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

Q: LoginManager and SQL-US?
by Wilkinson Charlie E 15 Jun '00

15 Jun '00

Ok, I've got this legacy database app (VisualBasic and Access - Bleck!) that I'm moving to Apache/Zope/PostgreSQL. One of the existing database tables is user info, i.e. userid, password, real name, an "account disabled" boolean, etc. I've figured out a really stupid way to "solve" the problem, essentially doing queries against the user table and having conditionals in every DTML object to determine if the user should be there or not. (Actually, I negated some of that silliness by incorporating SQLSession into the mix.) Still, I'm faced with needing some way to check the user/session against each requested object. And no, there's not much access granularity here - the user should either have access to the whole folder, or not. LoginManager looks promising, but I'm still enough of a Zope newbie that I've hit a bit of a roadblock, boiling down (boiled roadblock?!?) to 2 fundemental questions: 1. Can LoginManager be (easily?) made to meet my specific need? 2. Has anyone done an SQL UserSource yet, or can anyone give me a clue how to make one? I've tried "creating" another US, but after that Zope just sits there, quietly mocking me. I did read the API stuff and that actually makes a little sense to me, but I don't know what types of objects (or external methods?) would need to be created as part of a new US interface. In other words, I more or less understand the API calls, I can do SQL queries in my sleep, but how does one tie it all together into a new US? Does it involve (*shudder*) writing Python? ;) I'd be happy to share back any useful results of this exercise. Thanks for any help, Charlie -- Charlie Wilkinson - TRIS Development Systems Administrator IS:SD:CT:CC:TD Phone: 202-283-3241 MSMail: Charlie E Wilkinson <mailto:Charlie E Wilkinson> SMTP: cwilkins(a)tris.irs.gov <mailto:cwilkins@tris.irs.gov> Home: cwilkins(a)boinklabs.com This message constructed from 90% post-consumer electrons.

5 4

Sorry about that....HTML POSTs
by J. Michael Mc Kay 15 Jun '00

15 Jun '00

It ws me, I admit it....... I'm breaking another bad habit (at least for threaded mail client users)...Posting from NEW MESSAGE verses choosing reply and changing the topic. Just can't win sometimes.

1 0

RE: [Zope] Version Paradox
by Baker, Dennis [sjmr] 15 Jun '00

15 Jun '00

No luck, Maybe I'm describing my problem wrong, When I go to manage Zope The header at the top says " Folder at / * (/Developement%20Site) ^ (This is the version Symbol) It doesn't Say that I am working in a version otherwise. Then if I attempt to create a new version I get the following error: Error Type: VersionLockError Error Value: ("'\\000\\000\\000\\000\\000\\000\\000\\002'", '/Developement%20Site') I can create a version in a subfolder, and subfolders don't have the "Folder at" stuff all messed up. Unfortunately this is my production server too, not my testing server. -----Original Message----- From: Cornelis J. de Brabander [mailto:brabander@fsw.leidenuniv.nl] Sent: Thursday, June 15, 2000 12:14 AM To: Baker, Dennis [sjmr]; zope(a)zope.org Subject: Re: [Zope] Version Paradox >I've inadvertently created a version paradox. I created a version and >joined it, then I realized that I did a stupid naming mistake I tried to >UNDO the creation of the version. It allowed me to undo the creation of the >version, however I was in the version at the time, and now I am stuck in >the version and cannot get out. I cannot create a version of the same name >and delete it either. I am stuck. HELP !! > >How can I exit a version that doesn't exist? > I believe that versions are based on cookies and that removing the culprit will unlock your paradox cb

2 1

[Fwd: [Zope] Version Paradox]
by Dan Rusch 15 Jun '00

15 Jun '00

1 0

[Fwd: [Zope] Version Paradox]
by Dan Rusch 15 Jun '00

15 Jun '00

1 0