September 2000 - Zope

Renderable Base Class ???
by Brian Withun 05 Sep '00

05 Sep '00

I'd read some discussion dating back to last year about a the concept of a Renderable Base ZClass; something that would allow a ZClass to be called like <dtml-var "myClassInstance"> Have there been any developments along this line, or any plans to incorporate the idea into Zope? I find myself in need of this functionality. Also, I did notice a product on Zope.org which claims to be a renderable base class, but it's a tgz and doesn't seem to uncompress for me on WinNT using WinZip7. Does anybody have a copy of this (working) that they might export and send? (It's a very small TGZ product and hopefully a very small zexp) ------------ Brian Withun

4 3

Java applet with inner classes causing probs in Zope
by Eric L. Walstad 05 Sep '00

05 Sep '00

Hello all, The problem is that inner classes have names like "Parent$Inner.class" I'm unable to create a Zope file object with a name that includes the dollar sign. However, the applet won't function without it. Has any one overcome this? Yes, the applet functions properly when served from apache (but I need to serve it from Zope). Please respond directly to me and mailing list as I am not currently on the mailing list. Thanks, Eric.

3 2

Stumped: Python in operator seems to not work
by Andy Dustman 05 Sep '00

05 Sep '00

(Please CC: me on responses.) I have a DTML Method (build_navigation_bar) that is called from standard_html_header to (surprise) build a navigation bar. standard_html_header invokes it thusly: <dtml-var "build_navigation_sidebar(start=_['foo'], parents=PARENTS)"> where foo is the top of the tree; standard_html_header can be acquired further down in the tree. parents is initialized to PARENTS, which is the list of parents of the original object. build_navigation_bar invokes itself on Folders that it finds that are among the parents of the original object. I.e., this is somewhat like a tree, but we only want to expand the branch we're in. This is done with: <dtml-in "start.objectValues(['Folder'])" sort=public skip_unauthorized> <dtml-with sequence-item> <dtml-if "hasProperty('public') and public"> <A HREF="<dtml-var absolute_url>"><dtml-var title_or_id></A><BR>  <dtml-if "this() in parents">  <dtml-var "build_navigation_sidebar(start=this(), parents=parents)"> </dtml-if> </dtml-if> </dtml-with> </dtml-in> Unfortunately, this doesn't work: The conditional is always false. Some of the debugging output:   Note that in the first line, the expression correctly evaluates to 0, while the second line incorrectly evaluates to 0. Using <dtml-var "this()"> should not, and does not, make a difference. Initializing parents with a copy of PARENTS (PARENTS[:]) does not make a difference, as expected. Direct comparisons, i.e. <dtml-var "this() is parents[0]"> (or ==) also fail. What did I overlook, because this seems like it ought to work. -- andy dustman | programmer/analyst | comstar.net, inc. telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d "Therefore, sweet knights, if you may doubt your strength or courage, come no further, for death awaits you all, with nasty, big, pointy teeth!"

2 1

ANN: Zope core session tracking proposal
by Chris McDonough 05 Sep '00

05 Sep '00

If you're interested in seeing session-tracking implemented in the Zope core, please review the proposal at http://dev.zope.org/Wikis/DevSite/Proposals/CoreSessionTracking and provide comments on the referenced discussion page. Thanks! Chris McDonough Digital Creations, Publishers of Zope http://www.zope.org

1 0

Date-Time or SQL (Oracle) time.. or...
by Chris Beaumont 05 Sep '00

05 Sep '00

Hello, Another newbie question that I hope doesn't sound too stupid.. (I guess I already know the answer to that question.. it DOES... *sheepish grin*) Have a little patience with me, I'm learning things and having fun, so in a month or three... *sigh* Anyway.... I have some questions about the best way to update time fields on my Zope site. This issue has been "the bane of my life" for the past three days.....*grin* Basically these are fields in records describing events (programs and workshops, and soon, talks) which I am listing on my site.. The dates are in an Oracle 7 table. I'm using DCOracle and the Zope OracleDA to interact with these data sources from Zope. Quite simply, I'm confused.. I've been following to the letter the ZSQL Methods Guide, but I'm completely missing something important about the relationship between Zope date-time and Oracle dates. I've scoured the lists and haven't found anything there either..How-tos deal with general date-time issues.. yes.. but this is on the border .. perhaps.. DateTime vs. Oracle SQL. *pause for dramatic effect* The How-tos I've seen don't answer several (basic) questions.. Note: So far I have just been working with dates, not hours, minutes, etc. I've noticed that if I insert data using Oracle's default and not very useful "native" format ie. 01-Jan-00 things work on the insert side. Sort-of... I've also successfully used "TO_DATE" to insert data in SQLMethods.. in forms I built myself.. But then using the exact same code in another (originally ZNolk-generated, but much edited..) form and SQL method.. no luck.. It's usually not even making it out of Zope's error check routines.. Perhaps this is a clue.. I've noticed that when displaying the results of a query, Zope translates Oracle's outputted dates into Date-Time. Does Zope also do translation on the input end? And if so, what do I need to do to be able to consistantly input dates in MM/DD/YYYY without problems.. I've been having major problems with <dtml-sqlvar> choking on dates and I don't have the foggiest idea what I am doing wrong. Do I need to put more effort into learning TO_DATE and TO_CHAR (Oracle-isms) better or am I totally barking up the wrong tree.. (i.e. Zope translates everything into Date-Time) What is the best way to intercept SQL so I can see what is being sent to Oracle..? (I followed the suggestions in the How-to on this subject and Zope threw an error) I'm sorry this sounds so stupid, but I have been running into a brick wall..so to speak.. And in my scheme of things, dates, and the simple modification of them.. is really important... Thank you, Chris

1 0

Folder and SQL security
by George 05 Sep '00

05 Sep '00

Security in ZOPE is very puzzling. If I have certain rules set for the root folder, can I set something different for the sub folders? Any changes seem to have no effect at all. I am especially wandering about setting for anonymous user. I'd like to give them only 'viewing' privilege but that does not work. The site is not functional at all and asks for the password even for the viewing. Then I enable 'access the content' and the site works as long as I do not try to use sql. When I how ever enable 'use sql methods' permission they can access my database, delete and add entries to it. What do I have to do to allow anonymous viewers to just view the site (keep in mind that I am using a couple of zsql methods for embedding of data in my html) I also want to have one of the sub folders not accessible to any one but me. Can you help anyone? Regards, George

4 3

Render the number of occurrence in a batch
by Francois-Regis CHALAOUX 05 Sep '00

05 Sep '00

Hi, How to render the total number of result coming from the search in a ZCatalog even if the batch will be render in several sequences ? Howto render XXXX : "Your search contain XXXX results" FR.

3 2

Nevermind? (SQLSession problem...)
by Charlie Wilkinson 05 Sep '00

05 Sep '00

In a last, desparate effort I downgraded to SQLSession 0.2.9a and it's working fine. Is this normal? -cw- -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Charlie Wilkinson - cwilkins(a)boinklabs.com - N3HAZ Parental Unit, UNIX Admin, Homebrewer, Cat Lover, Spam Fighter, HAM, SWLer... Visit the Radio For Peace International Website: http://www.rfpi.org/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CLOBBER INTERNET SPAM: See!! <http://spam.abuse.net/> Join!! <http://www.cauce.org/> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ QOTD: Failure is not an option. It's bundled with your software.

1 0

Managed Meeting semi-broken in 2.2.1
by Bill Anderson 05 Sep '00

05 Sep '00

It appears that there has been _some_ change in security somewhere. As Manager, I cannot add a Managed Meeting object in a Zope 2.2.1 server. Nor can someone with the role 'Member', who has been given the neccessary permission. It tells me I don't have uthroization to access 'ManagedMeeting'. Bill -- Do not meddle in the affairs of sysadmins, for they are easy to annoy, and have the root password.

1 0

Arrrgh!!! *Weird* SQLSession problem
by Charlie Wilkinson 05 Sep '00

05 Sep '00

Ok, all weekend I've been chasing my tail. Now I scream for help... I cannot get SQLSession to insert values into the zsession_data table to save my freeking life. I'm not getting errors of any kind, just no inserted session data. However, the zsessions table shows the sessions being created, so that table is working ok. I mangled the SQL syntax for sqlSetValue, *then* I got a pg. error, so sqlSetValue *is* running, yes? I installed Logger and logged the values from sqlSetValue to the zope log. I cut and pasted those values from the log into the test query screen for sqlSetValues and when I submit the query it inserts just fine. At that point I can see the manually inserted values from session_test.dtml, so sqlGetValues is working. But if I try to insert values with session_test, they show up in the very next screen, but are gone thereafter and of course they do not show up in the database. I'm really at quite a loss here. I made sure to give SQLSession its very own ZPyGresQLDA connection. After beating on that unsuccessfully for awhile, I installed ZPoPyDA, and set SQLSession to use that, which of course didn't change anything. Here's the version particulars: Zope version: Zope 2.1.6 (source release, python 1.5.2, linux2) Python version: 1.5.2 (#1, Sep 17 1999, 20:15:36) [GCC egcs-2.91.66 19990314/Linux (egcs- System Platform: linux-i386 ZPyGreSQLDA 0.3 ZPoPyDA 0.5.1 PoPy 1.3.2 beta SQLSession 0.3.0 PostgreSQL 7.0.2 Other installed products (if it matters...): ZPyGreSQLDA Fortune Calendar Logger Photo ZPatterns Confera LoginManager SQLSession ZPoPyDA WorldPilot iTrack Mild rant: I've got a big, scary, and now behind schedule database-enabled website to build for a client. Most everything I've read, and even my earlier, simpler experiences with Zope have been fantastic. I've been going on to my client about how great Zope is, rapid deployment, etc, blah. So I committed, but after fighting with LM (It took weeks to get it working once and I have not been able to duplicate that feat since), a failed upgrade to Zope 2.2 (LM wouldn't work there yet(?), doh!), and now SQLSession... I'm *not* having an overall good feeling about all this. I'm even starting to get thoughts of retreating to Perl or learning PHP3 and never looking back. But I really want to get over what's probably mostly newbie learning curve & lack of docs and make this work in Zope. Please help!!! -cw- -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Charlie Wilkinson - cwilkins(a)boinklabs.com - N3HAZ Parental Unit, UNIX Admin, Homebrewer, Cat Lover, Spam Fighter, HAM, SWLer... Visit the Radio For Peace International Website: http://www.rfpi.org/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CLOBBER INTERNET SPAM: See!! <http://spam.abuse.net/> Join!! <http://www.cauce.org/> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ QOTD: Failure is not an option. It's bundled with your software.

1 0