[Zope] newbie Q.stylesheet 'title'

2000-06-02 Thread Brad Moulton

The 'title' that appears to the right of an object in a folder

Does this need to be included in a style
sheet for access.

I have been messing  around with the zope zclasses howto and notice the use
of  RTC to generate unique "id"'s
to add some meaning to this  they also use "title"

eg. if one created a zope method and gave it a title
how does this differ from the title definded in a style sheet.

brad


___
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] Form POST Question (and a QUERY_STRING Q.)

2000-06-02 Thread Daryl Tester

Stuart 'Zen' Bishop wrote:

> And another item from 'Sticky Tape & String Crackpot Solutions R Us':
> 
> Write an external method that calls Pythons urllib or httplib methods to
> suck in the desired URL and return it. You may be able to use
> this as a replacement to redirect.

A while ago, I wrote something like (well, actually, it was exactly like):

from urllib import urlencode

def addRequestURL(REQUEST, url, dict = {}):
"Return an URL with REQUEST.form encoded as a query string."
newREQ = {}
# Copy REQUEST.form
for key, val in REQUEST.form.items():
newREQ[key] = val
# Overwrite with supplied values.
for key, val in dict.items():
newREQ[key] = val
return url + '?' + urlencode(newREQ)

which allows you to add new/modify existing items in the query string.
Would that help, Mr Person Who Originally Started This Thread?

"Antipodean Hacks R Us"


Regards,
  Daryl Tester

___
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] secure area?

2000-06-02 Thread Bill Anderson

michael angelo ruberto wrote:
> 
> hi,
> 
> i need some help with permissions again. is there a way to make a subfolder
> secure from people with manager roles in the parent folder? i've tried
> different settings but nothing locks them out. thanks.



 You might be able to duplicate their username in an scl_users folder in
the 'secure' directory, and give them a random password. The local
acl_users would take priority, thus locking them out unless they know
the (randomly generated, hard-to-crack) password.


It may or may not work, but i believe it will, having accidentally shot
myself in the foot before doing something simliar.

___
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] Multiple Zopes on NT

2000-06-02 Thread Andy McKay

Can anyone point me to a how to on running multiple instances of Zope on NT?


___
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] SV: [Zope] Q: Link status/checking

2000-06-02 Thread Jшrgen Skogstad

Hi there.. 

Sure! I just did a quick read through of the url you posted and it
looks to me that you've started with what I want. I am very interested
in getting this to work within the Zope framework as well.. with 
Sql support etc. as I am doing a project that would require "robotic"
features! ;) Don't we just hate manual labour. ;) 

.. I'll take a look at what you've done .. and get back to you later this
weekend. I'm in the process of moving and I have a @34@? of
packing to do.

Ttyl.. 

.. and have a real nice day!

Kindest,
Jorgen 

- Opprinnelig melding - 
Fra: Oleg Broytmann <[EMAIL PROTECTED]>
Til: JÛrgen Skogstad <[EMAIL PROTECTED]>
Kopi: <[EMAIL PROTECTED]>
Sendt: 1. juni 2000 12:39
Emne: Re: [Zope] Q: Link status/checking


> Hi!
> 
>I am working on such project for a few years. From time to time I make
> an announcement in comp.lang.python, subject "Bookmarks database and
> Internet robot". This is a copy of my latest announce:
>http://www.deja.com/=dnc/getdoc.xp?AN=626677041
> 
>It my hobby project, in pure Python. Wanna cooperate on this?
> 
> On Thu, 1 Jun 2000, [Windows-1252] Jørgen Skogstad wrote:
> > I was wondering about a few points I havn't seen any references
> > to. Are there any implementations in Zope that can verify the 
> > validity of an url? That is; 
> > 
> > 1) A link database is generated .. and should be maintained.
> > 2) A process should be run at least once a week to check the
> >validity of links in the database. 
> > 3) If the link is not "valid" .. it sets a tag in the db which
> >says it's untrusted .. which again could show that in the
> >link listed on the web through Zope.
> > 4) .. and if it's untrusted for N runs .. it is removed.
> > 
> > .. have anyone looked into that? .. and anyone made any conclusions
> > as to how one can solve that?
> 
> Oleg.(All opinions are mine and not of my employer)
>  
> Oleg Broytmann  Foundation for Effective Policies  [EMAIL PROTECTED]
>Programmers don't die, they just GOSUB without RETURN.
> 
> 


___
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] Using sql to search in zope

2000-06-02 Thread Stuart 'Zen' Bishop

On Fri, 2 Jun 2000 [EMAIL PROTECTED] wrote:

> I tried to build a search feature using sql in zope, this is what I normal
> do in sql to do a range search :
> 
> select * from table1 where table1_id = %field1_value%
> 
> But when I try it with zope, it will become
> 
> select * from table1 where table1_id = %'value'%

The quoting is there to protect you (if value contains the SQL delimiter ';'
or whatever it is in Access, bad things can happen and might be a big
hairy security hole).

Try:



select * from table1 
where 





You might need an 'op=like' attribute to the sqltest tag (I don't know Access).

-- 
Stuart Bishop  Work: [EMAIL PROTECTED]
Senior Systems Alchemist   Play: [EMAIL PROTECTED]
Computer Science, RMIT University


___
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] Form POST Question (and a QUERY_STRING Q.)

2000-06-02 Thread Stuart 'Zen' Bishop

On Thu, 1 Jun 2000, Andrew H. Chatham wrote:

> You can of course change it all into GET data and just join them
> together using:
>'%s=%s' % (url_quote_plus(name), url_quote_plus(data))
> and joinging with &, in which case you actually can do a redirect, but
> presumably someone made it POST for a reason, so I'm not going to mess
> with it. It's an inelegant solution and might not work for everything,
> but it's all I have for now!

And another item from 'Sticky Tape & String Crackpot Solutions R Us':

Write an external method that calls Pythons urllib or httplib methods to 
suck in the desired URL and return it. You may be able to use
this as a replacement to redirect.

-- 
Stuart Bishop  Work: [EMAIL PROTECTED]
Senior Systems Alchemist   Play: [EMAIL PROTECTED]
Computer Science, RMIT University


___
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] Linuxtag update

2000-06-02 Thread Stephan Richter

I just got this mail from Martin Schulze, our contact at Linuxtag.

>Moin,
>
>die Raumfrage ist geklaert, es stehen Raeumlichkeiten zur Verfuegung,
>genaueres schreibe ich euch morgen oder uebermorgen.  Ihr koennt also
>mit den Planungen fuer die ZopeCon beginnen.
>
>Kurz noch: 1 Raum mit Stuehlen und Tischen: 28 Plaetze, 1 Raum mit
>nur Stuehlen: 50 Plaetze.  Moeglicherweise gibt's noch einen groesseren
>Raum, dazu muss ich aber erst wieder wach sein.

Translation:

Mornin,

The question about the rooms is answered, and there will be rooms for your 
usage. More details will come tomorrow and on Sunday. So you can start with 
your preparations for the ZopeCon [Zope Conference].

Pretty fast: 1 room with chairs and tables: 28 seats; 1 room only with 
chairs: 50 seats. It is possible that there will be another bigger room, 
but to confirm that I have to be awake again [message was sent 1:00 am his 
time].


He also just replied that we will have Internet access in the rooms.

Regards,
Stephan
--
Stephan Richter
PlanDepot.com - Senior Application Developer and Technical Project Lead
Cell: (901) 573-3308


___
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] NEWS: Zope passes xml-rpc validation tests!

2000-06-02 Thread Phil Harris

Hi all,

Following a post by Dave Winer on ZopeNewbies:

http://weblogs.userland.com/zopeNewbies/discuss/msgReader$617

I took up the challenge and am glad to report that Zope validates 100%
against the test webapp.

See ya

Phil
[EMAIL PROTECTED]



___
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] jcNTUserFolder and trusted domains

2000-06-02 Thread Erik Myllymaki

I am running Zope on NT without IIS. I installed jcNTUserFolder, but I
cannot get users from a trusted domain to log in. I added these users in the
*add users from other domains screen*.

Any help appreciated.

Erik Myllymaki
[EMAIL PROTECTED]


___
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] [ANN] Zope at Linuxtag 2000 in Stuttgart

2000-06-02 Thread Stephan Richter

Hello everyone,

A couple of days back Martijn Faassen and I had the idea to organize a 
European Zope conference. Maik Roeder reminded me of the upcoming Linuxtag 
2000 in Stuttgart. So I contacted the Linuxtag staff and we will have a 
booth. Martin Schulze, my main contact, will  also try to get a Zope 
Conference setup for us, which would give us 2 rooms for one day fitting 50 
people per room, where we can have talks and discussions.

The Linuxtag will be from June 29th (Thursday) to July 2nd (Sunday). It 
will be in the Exhibition Center (Messegelaende) in Stuttgart, Germany.

I know we have little time to organize the conference (26 days). We have 
one day to fill with speeches and discussions, so please let me know if 
there are people willing to give some talks or want to have "Special 
Interest Group" discussions, like E-commerce, XML or Portals in Zope. I 
would also like to know, who would be able to come, so I can give the 
Linuxtag staff some feedback.

Here are some subjects I thought we could have: The ZDP Portal (Maik 
Roeder, ), XML in Zope (I know Martijn F. did a lot of work there. ;-), 
An Introduction to Zope for newbies (Stephan Richter -- me), ZClasses, 
Python Products for Zope and so on.

I also would like to hear some talks and discussions about Python products 
that Zope uses, such as PyGres, PIL, mxDateTime and other modules. I would 
be very glad, if some Python-only people would show some interest too. :-)

The speeches and discussion can be held in German and English (preferred, 
since we expect people from other countries).

So, everyone who is interested in preparing a talk or discussion, please 
send me an E-Mail and I will compile it to a schedule. The rooms will be 
open for us between 9:00 am - 8:00 pm on Thursday the 29th.

Let's make this a successful event!

Regards,
Stephan

--
Stephan Richter
CBU - Physics and Chemistry
Web2k - Web Design/Development & Technical Project Management


___
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] Two issues for Z2.2: XHTML & malicious tags

2000-06-02 Thread Alexander Limi


Evan Simpson:
> I've got a rather crude module going which parses an input string for
> HTML-ish tags.  It allows only tags from an explicit list, and
> ensures that
> non-empty tags are closed (either by complaining or adding closing tags).
> If 'script' is not one of the allowed tags, it also disallows all "On*"
> attributes and "javascript:*" attribute values in any tag.
>
> Unfortunately, it isn't very efficient (based on sgmllib.py) and is rather
> crude.  I had wanted to make it use SAX to do the parsing, so
> that sgmlop or
> another high-performance library could be plugged in, but never got there.
> Also, it has no DTML-level interface; you'd have to wrap it in an External
> Method to use it from DTML.
>
> I've gone ahead and put it up at
> http://www.zope.org/Members/4am/SafeHTML to see if anyone can
> make anything of it.

This looks a lot like the code I have lying around, only yours is more
comprehensive and user friendly :)

Anyway, I assume you are familiar with SAX for Python?

http://www.stud.ifi.uio.no/~lmariusg/download/python/xml/saxlib.html

It supports sgmlop, like you mentioned.

Your code will do beautifully for our project, we are not dependant upon
fast code in that specific part. Thanks a lot.

Now, can somebody tell me how to help Zope with spitting out XHTML
1.0-compliant tags? :]

--
Alexander Limi
[EMAIL PROTECTED]


___
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] secure area?

2000-06-02 Thread michael angelo ruberto

hi,

i need some help with permissions again. is there a way to make a subfolder
secure from people with manager roles in the parent folder? i've tried
different settings but nothing locks them out. thanks.

--


___
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] something missing in my Oracle setup?

2000-06-02 Thread Alexandre A. Drummond Barroso

I'm having the same kind of problem.
This is my environment:

RedHat Linux 6.1
Stronghold 2.4.2/Apache1.3.6
Zope 2.1.6 (running as PCGI)
DCOracle 1.3.0
ZOracleDA 2.1.0
Oracle 8.1.6 (client with C-Pro environment installed)

The environment is properly set: LD_LIBRARY_PATH is correct, ld.so.conf was properly 
modified and I've already run ldconfig.
I've successfully compiled the DCOracle product and tested it with success.

But when I try to create a ZOracle connection object, the server gives me the 
following answer: "Internal Server Error - The server
encountered an internal error or misconfiguration and was unable to complete your 
request". And here is the message I've found in
the error log file: "[error] PCGI Error: [503 Service Unavailable] ((116) unable to 
connect, fd=4) Success".

Does anybody know what is happening and how to solve this?

TIA,

Alexandre.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 31, 2000 10:44 AM
To: [EMAIL PROTECTED]
Subject: Re: [Zope] something missing in my Oracle setup?


I wanted to thank Jens and Anthony for the pointers.

I ended up doing the full server install.  The only other thing
required was to put $ORACLE_HOME/lib in my ld.so.conf and run ldconfig.

Things seem to work fine now, though I haven't really hammered on
DCOracle yet.

Thanks again,

-Justin



___
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] Strange Zope behavior/Instability (Zope going down)

2000-06-02 Thread Jason Spisak

Rob Sporleder writes:

> The shell was on my local machine...
> 

That's the same as tryinga browser for network purposes.  Can you try
bringing up a shell on the server next time and try a wget
http://localhost:8080, and see if it returns anything.  If so, the Zope is
fine and it's that other stuff, like network cards etc...

> BigBrother is the monitoring software we use. The client is installed on the
> same server as Zope.
> 
> When viewing the log files there were no connections made by BigBrother
> (checking for http connections). However, there were many hits from outside
> IP's.
> 
> Thanks,
> Rob
> 
> -Original Message-
> From: Jason Spisak [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 02, 2000 10:17 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [Zope] Strange Zope behavior/Instability (Zope going down)
> 
> 
> Rob Sporleder writes:
> 
> > It was the command line within the shell.
> 
> Was it the shell on the 'server' serving zope or a shell on your local
> admin machine?
> 
> >Actually, I've found something
> > that's interesting...
> >
> > The system clock is an hour slow.
> 
> They get behind easily if your not using an time server somewhere.
> 
> >The logs are written 6 hours ahead.
> 
> I have no idea on that.
> 
> >I
> > greped the log file for BigBrother and found an hour gap with no
> BigBrother
> 
> Is BigBrother the Zope server?
> 
> > entries from 06:37:53 and 07:40:23, roughly the time that the site seemed
> to
> > go down. However, during this time there were hundreds of successful hits
> to
> > the site.
> 
> What told you there were successful hits? The Zope log?  If understanding
> you, you are seeing confilcting things in 2 logs. One log says there was
> successfull hit, and the other shows nothing for that time.  Is this close?
> 
> >
> > Rob Sporleder writes:
> >
> > > All of the python z2.py processes are still running. I haven't checked
> if
> > I
> > > can get to it using http://localhost. The server is offsite. However, I
> > did
> > > try an http get from the command line and it did not respond.
> > >
> >
> > Was it the command line on the server?
> > from the server shell:
> >
> > $>wget http://localhost:8080
> >
> > I'm trying to narrow it down to the real culprit.  We can't be sure it's
> > Zope and not the DNS/Machine/Routing/Firewall/ or anything else.
> >
> > > -Original Message-
> > > From: Jason Spisak [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, May 31, 2000 1:13 PM
> > > To: [EMAIL PROTECTED]
> > > Cc: [EMAIL PROTECTED]
> > > Subject: Re: [Zope] Strange Zope behavior/Instability (Zope going down)
> > >
> > >
> > > Rob Sporleder:
> > >
> > > > I received a server not responding error. We lost connectivity twice
> on
> > > > Friday as well. I setup a script to restart the server every X minutes
> > so
> > > we
> > > > wouldn't have to worry about it over the weekend. I removed the
> cronjob
> > on
> > > > Tuesday morning and it was fine until early Wednesday morning when it
> > went
> > > > down three times in 30 minutes.
> > > >
> > > > Thanks,
> > > > Rob
> > > >
> > >
> > > Wow. Ugly.  Are the Zope processes still up after you've lost
> > connectivity?
> > >  If so, can you get a browser on the machine running zope to access it?
> > > http://localhost:8080, or whatever port your running on.
> > >
> > > > -Original Message-
> > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> Jason
> > > > Spisak
> > > > Sent: Wednesday, May 31, 2000 12:10 PM
> > > > To: [EMAIL PROTECTED]
> > > > Cc: [EMAIL PROTECTED]
> > > > Subject: Re: [Zope] Strange Zope behavior/Instability
> > > >
> > > >
> > > > Rob Sporleder:
> > > >
> > > > > For reasons unknown we lost http connectivity to our Zope server
> three
> > > > times
> > > > > last night.
> > > >
> > > > When you say lost connectivity, do you mean the browsers gave you back
> a
> > > > 'Server Not Resonding' message, or was is as if Zope was just spinning
> > > it's
> > > > wheels?  If it was the latter, how long did you wait to see if you did
> > get
> > > > a response? 1 minute, 10, 30?
> > > >
> > > > >I've checked the http logs and, as I suspected, didn't find
> > > > > anything unusual around the time we lost connectivity. The Python
> > > > processes
> > > > > are still running and everything looks normal except for the
> > > connectivity
> > > > > problem. Does anybody have any idea what might be causing this? I
> > > haven't
> > > > > found anything.
> > > > >
> > > >
> > > > This happened to me, but it caused a single process to chew CPU.
> Since
> > > you
> > > > noticed no such chewing, I'll bet it's not the DTML decapitation bug.
> > > >
> > > > > Here are some specifics about our setup...
> > > > >
> > > > > version of python:
> > > > > 1.5.2
> > > > >
> > > > > operating system:
> > > > > Linux 2.2.12-20smp (Redhat 6.1)
> > > > >
> > > > > services running on machine:
> > > > > MySQL
> > > > > 2 instances of Zope
> > > > > Python
> > > > >
> >

[Zope] ZJetDA

2000-06-02 Thread Luis Cortes

Hi,

I hope someone out there is using this.  I hope also that you might
have seen this error and can tell me how to fix it.  

IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx,
pythoncom.IID_IDispatch)
com_error: (-2147221230, 'CLASS_E_NOTLICENSED', None, None )

during my Zope 2.1.6 start up.  Does anyone have any clues??

Thanks for any help,
Luis.
 nt-zjet.jpg


Re: [Zope] Two issues for Z2.2: XHTML & malicious tags

2000-06-02 Thread Evan Simpson

- Original Message -
From: Alexander Limi <[EMAIL PROTECTED]>
> 2. Malicious HTML tags - is anything being done here? Filtering of these
is
> one of the features Zope 2.2 really shouldn't go without. Most Zope sites
> have user interaction in some way, and the concept of a post containing a
> stray , or even worse - script-tags, destroying a page is totally
> unacceptable IMHO. I'd just like to query what the status is on this, as I
> think it is one of the most overlooked areas that are lacking in Zope.
>
> I know Evan Simpson (malicious tags) and Christopher Petrilli (HTML
quality
> of zope) have been talking about this earlier, any comments?

I've got a rather crude module going which parses an input string for
HTML-ish tags.  It allows only tags from an explicit list, and ensures that
non-empty tags are closed (either by complaining or adding closing tags).
If 'script' is not one of the allowed tags, it also disallows all "On*"
attributes and "javascript:*" attribute values in any tag.

Unfortunately, it isn't very efficient (based on sgmllib.py) and is rather
crude.  I had wanted to make it use SAX to do the parsing, so that sgmlop or
another high-performance library could be plugged in, but never got there.
Also, it has no DTML-level interface; you'd have to wrap it in an External
Method to use it from DTML.

I've gone ahead and put it up at http://www.zope.org/Members/4am/SafeHTML to
see if anyone can make anything of it.

Cheers,

Evan @ digicool & 4-am


___
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] Access to parents from Python

2000-06-02 Thread Pete Kazmier

I've solved my problem.  After toying around a bit this is what I came
up with:

 def ZopeRefreshRoot(self):
 p = self
 while p.getParentNode().getNodeName() == 'GWPoolClass':
 p = p.getParentNode()

Where p is now the topmost object of type 'GWPoolClass'.

On Fri, Jun 02, 2000 at 11:55:56AM -0400, Pete Kazmier wrote:
> Got a quick question ... couldn't seem to find an answer in the
> archives.  I have a container object based on a ZClass, lets call it a
> 'pool', that holds other objects and more of these 'pools'.  
> 
> How do I, in python, traverse up the tree to find the topmost 'pool'?
> I need to execute a method on the topmost 'pool' object which in turn
> will recursively update the cache on every pool in the tree.
> 
> Thanks!!
> Pete
> 
> -- 
> Peter Kazmier http://www.kazmier.com
> PGP Fingerprint   4FE7 8DA3 D0B5 9CAA 69DC  7243 1855 BC2E 4B43 5654
> 
> ___
> 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 )
> 

-- 
Peter Kazmier http://www.kazmier.com
PGP Fingerprint   4FE7 8DA3 D0B5 9CAA 69DC  7243 1855 BC2E 4B43 5654

___
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] Two issues for Z2.2: XHTML & malicious tags

2000-06-02 Thread J M Cerqueira Esteves

On Fri, Jun 02, 2000 at 06:50:46PM +0200, Alexander Limi wrote:
> 1. The HTML that Zope outputs is not very standards-compliant (XHTML 1.0) at
> the moment. Tags like  are rendered as  etc. I would like to

Perhaps support for XHTML-compliance in Zope should be optional.  I
wrote a few pages in XHTML some time ago, had no problems with
Netscape 4.xx, but was later informed of a few problems by some users.
Some still abundant browser versions were particularly not grokking
(and thus showing the user) the processing instruction

  

For generally accessible pages, I'm therefore still using HTML 4.0.

This is mentioned on http://www.w3.org/TR/xhtml1/:

 Be aware that processing instructions are rendered on some user
 agents. However, also note that when the XML declaration is not included
 in a document, the document can only use the default character encodings
 UTF-8 or UTF-16.

Anyway, tags like  are considered valid HTML 4.0 by the W3C validator,
so they would not cause validation "noise" for those still using HTML 4.0.

-- 
 jmce: +351 919838775 ~ http://artenumerica.com/ ~ http://artenumerica.org/

___
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] Strange Zope behavior/Instability (Zope going down)

2000-06-02 Thread Rob Sporleder

The shell was on my local machine...

BigBrother is the monitoring software we use. The client is installed on the
same server as Zope.

When viewing the log files there were no connections made by BigBrother
(checking for http connections). However, there were many hits from outside
IP's.

Thanks,
Rob

-Original Message-
From: Jason Spisak [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 02, 2000 10:17 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [Zope] Strange Zope behavior/Instability (Zope going down)


Rob Sporleder writes:

> It was the command line within the shell.

Was it the shell on the 'server' serving zope or a shell on your local
admin machine?

>Actually, I've found something
> that's interesting...
>
> The system clock is an hour slow.

They get behind easily if your not using an time server somewhere.

>The logs are written 6 hours ahead.

I have no idea on that.

>I
> greped the log file for BigBrother and found an hour gap with no
BigBrother

Is BigBrother the Zope server?

> entries from 06:37:53 and 07:40:23, roughly the time that the site seemed
to
> go down. However, during this time there were hundreds of successful hits
to
> the site.

What told you there were successful hits? The Zope log?  If understanding
you, you are seeing confilcting things in 2 logs. One log says there was
successfull hit, and the other shows nothing for that time.  Is this close?

>
> Rob Sporleder writes:
>
> > All of the python z2.py processes are still running. I haven't checked
if
> I
> > can get to it using http://localhost. The server is offsite. However, I
> did
> > try an http get from the command line and it did not respond.
> >
>
> Was it the command line on the server?
> from the server shell:
>
> $>wget http://localhost:8080
>
> I'm trying to narrow it down to the real culprit.  We can't be sure it's
> Zope and not the DNS/Machine/Routing/Firewall/ or anything else.
>
> > -Original Message-
> > From: Jason Spisak [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, May 31, 2000 1:13 PM
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [Zope] Strange Zope behavior/Instability (Zope going down)
> >
> >
> > Rob Sporleder:
> >
> > > I received a server not responding error. We lost connectivity twice
on
> > > Friday as well. I setup a script to restart the server every X minutes
> so
> > we
> > > wouldn't have to worry about it over the weekend. I removed the
cronjob
> on
> > > Tuesday morning and it was fine until early Wednesday morning when it
> went
> > > down three times in 30 minutes.
> > >
> > > Thanks,
> > > Rob
> > >
> >
> > Wow. Ugly.  Are the Zope processes still up after you've lost
> connectivity?
> >  If so, can you get a browser on the machine running zope to access it?
> > http://localhost:8080, or whatever port your running on.
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Jason
> > > Spisak
> > > Sent: Wednesday, May 31, 2000 12:10 PM
> > > To: [EMAIL PROTECTED]
> > > Cc: [EMAIL PROTECTED]
> > > Subject: Re: [Zope] Strange Zope behavior/Instability
> > >
> > >
> > > Rob Sporleder:
> > >
> > > > For reasons unknown we lost http connectivity to our Zope server
three
> > > times
> > > > last night.
> > >
> > > When you say lost connectivity, do you mean the browsers gave you back
a
> > > 'Server Not Resonding' message, or was is as if Zope was just spinning
> > it's
> > > wheels?  If it was the latter, how long did you wait to see if you did
> get
> > > a response? 1 minute, 10, 30?
> > >
> > > >I've checked the http logs and, as I suspected, didn't find
> > > > anything unusual around the time we lost connectivity. The Python
> > > processes
> > > > are still running and everything looks normal except for the
> > connectivity
> > > > problem. Does anybody have any idea what might be causing this? I
> > haven't
> > > > found anything.
> > > >
> > >
> > > This happened to me, but it caused a single process to chew CPU.
Since
> > you
> > > noticed no such chewing, I'll bet it's not the DTML decapitation bug.
> > >
> > > > Here are some specifics about our setup...
> > > >
> > > > version of python:
> > > > 1.5.2
> > > >
> > > > operating system:
> > > > Linux 2.2.12-20smp (Redhat 6.1)
> > > >
> > > > services running on machine:
> > > > MySQL
> > > > 2 instances of Zope
> > > > Python
> > > >
> > > > machine specifics:
> > > >
> > > > CPU: 0.04
> > > > MEM: 31M of 512M
> > > > Swap: 528688K free
> > > > Disk Space: GB's available on all partitions
> > > > Hardware: 598 Mhz Pentium III, 4 17.4 GB SCSI hard disks
> > > >
> > > > version of Zope:
> > > > 2.1.4
> > > >
> >
> > Jason Spisak
> > CIO
> > HireTechs.com
> > 6151 West Century Boulevard
> > Suite 900
> > Los Angeles, CA 90045
> > P. 310.665.3444
> > F. 310.665.3544
> >
> > Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email
> > address may not be added to any commercial mail list with out my
> > permission.  Vio

[Zope] Two issues for Z2.2: XHTML & malicious tags

2000-06-02 Thread Alexander Limi

Zopistas,

I have two issues that I think should be rectified before the 2.2 release. I
am not very up to date on the goings-on in the list, but a quick search gave
me little information on the following:

1. The HTML that Zope outputs is not very standards-compliant (XHTML 1.0) at
the moment. Tags like  are rendered as  etc. I would like to
contribute to the cleanup work, but I am a relative newcomer to CVS. How can
I participate? Do I just check out the relevant files, modify them and then
get somebody that is authorized to review the files and put them back in the
CVS?

I am not a guru when it comes to Python, but I know enough to not mess up
things along the way :)

And just to clarify: I'm not talking about a rewrite of the Zope management
console here, that will work fine until the Mozilla version comes along - I
merely want to make sure that tags are lowercase and terminated, so pages
produced by Zope stand a chance when passing through the W3C validator. I
always write compliant code when I have the chance, but when using Zope this
is impossible, as the tags that are inserted invalidate the page anyway.

So, who do I bribe to have a shot at the CVS? :)

2. Malicious HTML tags - is anything being done here? Filtering of these is
one of the features Zope 2.2 really shouldn't go without. Most Zope sites
have user interaction in some way, and the concept of a post containing a
stray , or even worse - script-tags, destroying a page is totally
unacceptable IMHO. I'd just like to query what the status is on this, as I
think it is one of the most overlooked areas that are lacking in Zope.

I know Evan Simpson (malicious tags) and Christopher Petrilli (HTML quality
of zope) have been talking about this earlier, any comments?

I'm really looking forward to Zope 2.2, the alpha release looks good so far.
You guys rock :)

Regards,


Alexander Limi.


___
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] Strange Zope behavior/Instability (Zope going down)

2000-06-02 Thread Jason Spisak

Rob Sporleder writes:

> It was the command line within the shell. 

Was it the shell on the 'server' serving zope or a shell on your local
admin machine?

>Actually, I've found something
> that's interesting...
> 
> The system clock is an hour slow. 

They get behind easily if your not using an time server somewhere. 

>The logs are written 6 hours ahead. 

I have no idea on that.

>I
> greped the log file for BigBrother and found an hour gap with no BigBrother

Is BigBrother the Zope server?

> entries from 06:37:53 and 07:40:23, roughly the time that the site seemed to
> go down. However, during this time there were hundreds of successful hits to
> the site.  

What told you there were successful hits? The Zope log?  If understanding
you, you are seeing confilcting things in 2 logs. One log says there was
successfull hit, and the other shows nothing for that time.  Is this close?

> 
> Rob Sporleder writes:
> 
> > All of the python z2.py processes are still running. I haven't checked if
> I
> > can get to it using http://localhost. The server is offsite. However, I
> did
> > try an http get from the command line and it did not respond.
> >
> 
> Was it the command line on the server?
> from the server shell:
> 
> $>wget http://localhost:8080
> 
> I'm trying to narrow it down to the real culprit.  We can't be sure it's
> Zope and not the DNS/Machine/Routing/Firewall/ or anything else.
> 
> > -Original Message-
> > From: Jason Spisak [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, May 31, 2000 1:13 PM
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [Zope] Strange Zope behavior/Instability (Zope going down)
> >
> >
> > Rob Sporleder:
> >
> > > I received a server not responding error. We lost connectivity twice on
> > > Friday as well. I setup a script to restart the server every X minutes
> so
> > we
> > > wouldn't have to worry about it over the weekend. I removed the cronjob
> on
> > > Tuesday morning and it was fine until early Wednesday morning when it
> went
> > > down three times in 30 minutes.
> > >
> > > Thanks,
> > > Rob
> > >
> >
> > Wow. Ugly.  Are the Zope processes still up after you've lost
> connectivity?
> >  If so, can you get a browser on the machine running zope to access it?
> > http://localhost:8080, or whatever port your running on.
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jason
> > > Spisak
> > > Sent: Wednesday, May 31, 2000 12:10 PM
> > > To: [EMAIL PROTECTED]
> > > Cc: [EMAIL PROTECTED]
> > > Subject: Re: [Zope] Strange Zope behavior/Instability
> > >
> > >
> > > Rob Sporleder:
> > >
> > > > For reasons unknown we lost http connectivity to our Zope server three
> > > times
> > > > last night.
> > >
> > > When you say lost connectivity, do you mean the browsers gave you back a
> > > 'Server Not Resonding' message, or was is as if Zope was just spinning
> > it's
> > > wheels?  If it was the latter, how long did you wait to see if you did
> get
> > > a response? 1 minute, 10, 30?
> > >
> > > >I've checked the http logs and, as I suspected, didn't find
> > > > anything unusual around the time we lost connectivity. The Python
> > > processes
> > > > are still running and everything looks normal except for the
> > connectivity
> > > > problem. Does anybody have any idea what might be causing this? I
> > haven't
> > > > found anything.
> > > >
> > >
> > > This happened to me, but it caused a single process to chew CPU.  Since
> > you
> > > noticed no such chewing, I'll bet it's not the DTML decapitation bug.
> > >
> > > > Here are some specifics about our setup...
> > > >
> > > > version of python:
> > > > 1.5.2
> > > >
> > > > operating system:
> > > > Linux 2.2.12-20smp (Redhat 6.1)
> > > >
> > > > services running on machine:
> > > > MySQL
> > > > 2 instances of Zope
> > > > Python
> > > >
> > > > machine specifics:
> > > >
> > > > CPU: 0.04
> > > > MEM: 31M of 512M
> > > > Swap: 528688K free
> > > > Disk Space: GB's available on all partitions
> > > > Hardware: 598 Mhz Pentium III, 4 17.4 GB SCSI hard disks
> > > >
> > > > version of Zope:
> > > > 2.1.4
> > > >
> >
> > Jason Spisak
> > CIO
> > HireTechs.com
> > 6151 West Century Boulevard
> > Suite 900
> > Los Angeles, CA 90045
> > P. 310.665.3444
> > F. 310.665.3544
> >
> > Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email
> > address may not be added to any commercial mail list with out my
> > permission.  Violation of my privacy with advertising or SPAM will
> > result in a suit for a MINIMUM of $500 damages/incident, $1500 for
> > repeats.
> >
> 
> 
> Jason Spisak
> CIO
> HireTechs.com
> 6151 West Century Boulevard
> Suite 900
> Los Angeles, CA 90045
> P. 310.665.3444
> F. 310.665.3544
> 
> Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email
> address may not be added to any commercial mail list with out my
> permission.  Violation of my privacy with advertising or SPAM will
> result in a suit for a

Re: [Zope] Using sql to search in zope

2000-06-02 Thread Jim Sanford




- Original Message - 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 02, 2000 3:10 AM
Subject: [Zope] Using sql to search in zope


Hi All,

I tried to build a search feature using sql in zope, this is what I normal
do in sql to do a range search :

select * from table1 where table1_id = %field1_value%

But when I try it with zope, it will become

select * from table1 where table1_id = %'value'%

Which return an error : [ODBC Microsoft Access 97 Driver] Syntax error in
query expression 'table1_id alike %'field1_value'%'.")

Any idea or work around ??

Please help

Cheers

Wai


___
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] Access to parents from Python

2000-06-02 Thread Pete Kazmier

Got a quick question ... couldn't seem to find an answer in the
archives.  I have a container object based on a ZClass, lets call it a
'pool', that holds other objects and more of these 'pools'.  

How do I, in python, traverse up the tree to find the topmost 'pool'?
I need to execute a method on the topmost 'pool' object which in turn
will recursively update the cache on every pool in the tree.

Thanks!!
Pete

-- 
Peter Kazmier http://www.kazmier.com
PGP Fingerprint   4FE7 8DA3 D0B5 9CAA 69DC  7243 1855 BC2E 4B43 5654

___
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] newbie Q. DTML syntax

2000-06-02 Thread andres

On Fri, Jun 02, 2000 at 11:27:55PM +1000, Brad Moulton wrote:
> 
> tried
> ---
>
>   
> 
>  j_number> ---
> and variations
> still no joy.

Your problem is probably not related to AUTHENTICATED_USER.getUserName() but
something else. The following works for me:


   
   
   
   
   
  Success!
   
  Failure!
   
   
   


Test sequence-item.title to make sure it is returning what you want.

--
Andres Corrada-Emmanuel   Email: [EMAIL PROTECTED]
--

___
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] Simple function nightmare

2000-06-02 Thread R. David Murray

On Fri, 2 Jun 2000, Felipe Alvarez Harnecker wrote:
>   b="'2'"
>  c="'3"
>  d=dontWork_dtml
> 
> 
> 
> 
> guess what: 
> 
> it renders
> 
> 2-2-3
> 
> That is d is not a string but an expression.

Hey, this is a cool trick .

What is happening here is that you are assigning the *function* to
d, not its result, so when you do the dtml-var, dtml calls the
function and it gets evaluated in the current context.  If you make
your let expression something like (untested):

d="dontWork_dtml(_.None,_)"

I think you'll get the result you were looking for.  (The _.None,_ pass
the namespace in to the method so that it can find a b and c.)

--RDM


___
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] Aquisition questions

2000-06-02 Thread Ian Sparks


Shane, your idea about extending the URL and putting in an extra folder in
the path will work but its a bit of a fix rather than a solution. Right now
this isn't a RealLife(TM) problem for me, just part of my trying to get to
grips with Zope and its potential pitfalls.

>>
Isn't there a way to cause the SQLMethods to provide "UserRowID" and
"FlavorRowID" instead?  That would be the most logical solution.
<<

Again, this is a good idea but it doesn't solve the fundamental problem
which is that URL's are meant to be traversed in a particular way, if the
"clever" user traverses them in a different way than intended you *could*
end up in a mess.

- Ian.


- Original Message -
From: "Shane Hathaway" <[EMAIL PROTECTED]>
To: "Ian Sparks" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 02, 2000 3:40 PM
Subject: Re: [Zope] Aquisition questions


Ian Sparks wrote:
> Is there a way to enforce URL's be traversed in a set way? Thus making :
>
> mysite.com/Users/Fred/Flavor/Cherry/test
>
> valid while mysite.com/Flavor/Cherry/Users/Fred/test becomes invalid.

You could set up an object called "Users" that would be found only if
the user goes through "Flavor" first.  Your example will have to be
modified to get it to work.

should work: mysite.com/Users/Fred/FlavorFolder/Flavor/Cherry/test

should not work: mysite.com/FlavorFolder/Flavor/Cherry/Users/Fred/test

FlavorFolder is a folder at the same level as Users.  It contains an SQL
query called Flavor and an object called Users.  The Users object in
this folder raises an exception, telling the clever user to back off.

Just a possibility.

> Also, assuming that both SQLMethods provide a "RowID", how do I specify
> explicitly which one I want, in OO terms :
>
> Users.RowID or Flavor.RowID

Isn't there a way to cause the SQLMethods to provide "UserRowID" and
"FlavorRowID" instead?  That would be the most logical solution.

Shane

___
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] Using FTP to connect to Zope server from (g)VIM

2000-06-02 Thread Phil Harris

Hi all,

My intellect was piqued recently by a discussion on the list about editors
for Zope etc.

I remember some people saynig that VIM was good, to which my response was,
'Yeah but there's no FTP built in'.

Someone then responded with a few scripts to do it.

Well I thought they were a bit cumbersome, so I wrote my own.

ftpopen.py and ftpsave.py.

If you have a VIM executable with Python support built in then these run
from within VIM and allow you to open/save file from/to Zope seamlessly. (I
have them on a menu in GVIM for instance)

I'll put the files up on my Zope Members bit
(http://www.zope.org/Members/philh) along with a few instructions.

If anybody can think of any enhancements then please let me know and I'll
see if I can work them in.

I hope these will be useful to someone.

See ya

Phil
[EMAIL PROTECTED]



___
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] ZPoPYDA thread safety level 1

2000-06-02 Thread Eric Bianchi


Dear ZPoPyDA users,

Many of you wonder what is the thread level of ZPoPYDA. As specified in the
Python DBAPI v2.0, our product is currently being tested to be thread safety level
1 which means that "Threads may share the module, but not connections".

Your feedback is welcomed. If you have any comments or suggestions, please use
our mailing-list : [EMAIL PROTECTED]

Regards

The PoPy team


___
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] Python and Zope Question

2000-06-02 Thread Kevin Dangoor

If object1 has a unique name in your acquisition path, you can get to it
simply through
self.object1.object2.object3

Otherwise, you can use PARENTS. I *think* you can get to the PARENTS list
via the REQUEST variable (so make sure you have REQUEST as a parameter in
your method).

REQUEST['PARENTS'][-1].object1.object2.object3

Kevin

- Original Message -
From: "Scott Burton" <[EMAIL PROTECTED]>
To: "Kevin Dangoor" <[EMAIL PROTECTED]>
Sent: Friday, June 02, 2000 12:21 AM
Subject: Re: [Zope] Python and Zope Question


> Thanks for the quick responses Kevin and R. David Murray! That did the
> trick. Now here is another quick one. How would I access an object from
the
> root-level? As in root.object1.object2.object3?



___
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] Problems with Postgres 7.0

2000-06-02 Thread Oleg Broytmann

Hi!

On 2 Jun 2000, Richard Taylor wrote:
> Has anyone else seen problems with ZPyGres and Postgres 7.0?

   Not me. I've upgraded to 7.0 without upgrading ZPygres - and now I am
running two Zope instances on the same computer, both opened 2-3
connections (totally 6 in peaks); all things go pretty good.

Oleg.(All opinions are mine and not of my employer)
 
Oleg Broytmann  Foundation for Effective Policies  [EMAIL PROTECTED]
   Programmers don't die, they just GOSUB without RETURN.


___
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] DTML newbie question on summation

2000-06-02 Thread Peter Sabaini


try 

  
:
:The days represent hours but are stored as integers in the database.
:
:- Bryan Patrick Coleman
:  Questcon Technologies
:  (336)273-2428
:  [EMAIL PROTECTED]
:
:
:___
: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 )
:

-- 

_
peter sabaini, mailto: [EMAIL PROTECTED]
-


___
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] DTML newbie question on summation

2000-06-02 Thread Marcus Collins

Hi!

> -Original Message-
> From: Coleman, Bryan [mailto:[EMAIL PROTECTED]]
> Sent: 02 June 2000 15:20
> To: '[EMAIL PROTECTED]'
> Subject: [Zope] DTML newbie question on summation
> 
> 
> I can't seem to add variables using let. I just get a 
> concatination of the integers. I am using ...
> 
> 
> 
> The days represent hours but are stored as integers in the database.

While they're stored as integers, some of the database adaptors return
everything as strings. This would seem to be borne out by the concatenation.

Try: 



to explicitly convert your results to integers.

hth,

-- Marcus

___
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] Problems with Postgres 7.0

2000-06-02 Thread Richard Taylor



I am having problems with the new release of Postgres (7.0). 

I have an application that has been connecting to a Postgres 6.5
database through ZPyGres without any problems. When I upgraded to 7.0
the query hangs the database connection and zope. Zope will not
respond to any requests until I manually kill the 'postgres' process
that is doing the query.

I can issue the query direct to postgres through the command line
without a problem.

I thought this might be something to do with ZPyGres not being thread
safe but I get the same results even if I force zope to only run 1
thread.

Has anyone else seen problems with ZPyGres and Postgres 7.0?

For now I have had to revert to Postgres 6.5.

I did see some discussion on this list recently about something called
ZPoPyDA but I can find no reference to it on the Zope web site. If
this is a development of a new Postgres DA I would be very interested
to see if it solves my problem, can anyone advice?

Many thanks

Richard


___
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] newbie Q. DTML syntax

2000-06-02 Thread Brad Moulton


tried
---
   
  

 ---
and variations
still no joy.
is the best way to mast the dtml syntax by learning python
I am afraid I feel lost reading the DTML  reference
can't when to use what syntax
feel like a moron can't even do a simple if statement
help appreciated

brad



> > As a newbie i have tried a few variations on the following
> > but the  never returns true
> >
> >  
> > 
> >   customer 
> > ...and other values from "customers" folder with meta type
customer
> > 
> > 
>
> This gets many, many people (including myself). Zope-defined Web request
> variables are usually objects. You are using AUTHENTICATED_USER as if it
was
> a string, which it is not, thus your dtml-if always fails.
>
> To get what you want, use (Zope Quick Reference v. 0.9):
>
>  AUTHENTICATED_USER.getUserName()
>
> Something that adds to newbies' confusion on this is that if one writes,
>
> 
>
> one gets the very username that one expects but yet the  still
fails.
> "I can see the freaking name is right Why are you failing!!???" is the
> expurgated version of what I said when I got bit by this one.
>
> The reason that  renders nicely to the same
> string that AUTHENTICATED_USER.getUserName() does is that
AUTHENTICATED_USER
> is an object of type lib/python/AccesControl/User. This object has the
> getUserName() method but it also has a "__str__" method that Python allows
> to be defined for any class. This "__str__" method is the way that an
object
> should be represented whenever it is printed. In the case of the User
class,
> lib/python/AccessControl/User.py defines the method __str__ as:
>
> def __str__(self): return self.getUserName()
>
> --
> Andres Corrada-Emmanuel   Email: [EMAIL PROTECTED]
> --
>
> ___
> 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] DTML newbie question on summation

2000-06-02 Thread Coleman, Bryan

I can't seem to add variables using let. I just get a concatination of the
integers. I am using ...



The days represent hours but are stored as integers in the database.

- Bryan Patrick Coleman
  Questcon Technologies
  (336)273-2428
  [EMAIL PROTECTED]


___
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] Re: Fwd: [Zope] postgres DA

2000-06-02 Thread Jim Sanford

Someone please correct me if I have gotten the stuff below wrong.
---
If I read the stuff on the PoPy web site correctly, it is a Level 2 Database
Adapter that is level 1 thread safe.

The level 1 refers to level of thread safety not database adapter level.

Level 1 thread safety means that multiple threads can share the module but
each thread must have its own database connection.

Level 2 thread safety means that multiple threads can share the module and
connections.

Level 3 thread safety means that multiple threads can share the module and
connections and cursors.

- Original Message -
From: "Bak @ kedai" <[EMAIL PROTECTED]>
To: "Federico Di Gregorio" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 02, 2000 4:10 AM
Subject: [Zope] Re: Fwd: [Zope] postgres DA


> I can only say that we started writing PoPy and ZPoPyDA because pygresql
> (and the adapter based on it) are *not* thread safe. we were experimenting
> deadlocks in zope when you mix db access from sql methods and external
> methods in the same page.

quoting DAroadmap at
http://www.zope.org/Members/petrilli/DARoadmap
"""

Level 2

Level 2 database adapters must be safe to use in a
multi-threaded Zope instance. This can take multiple behaviour
paterns:

Internal locking/mutexes for single DA access

Global locking through the transaction manager if
appropriate

While a sub-optimal solution, it should be usable on any
application that has minimal, or infrequent, database access.
This means that all access paterns will be serialized.

In addition, all DAs at this level must release the
Python global interpreter lock.
"""
i assume ZPoPyDA conform to the above statement.  will you make ZPoPyDa into
level 3 anytime soon?

>
> on the other hand PoPy is pretty new and, before using it in production,
> needs more testing. i think it will stabilize pretty soon, because we will
> use it to build the web sites for our customers really soon now and that
> will apport a lot of testing/debugging.
>

i will try ZPoPyDA on my personal site, and will inform you of any
misbehaviour.  BTW, what symptoms should i look out for if ZPoPyDa
misbehave?
Zope locking/not responding?


>make your choice and be happy,
made mine already, thanks, and

"""
I'll be back!
"""


> federico
>
> --
> Federico Di Gregorio
> MIXAD LIVE System Programmer   [EMAIL PROTECTED]
> Debian GNU/Linux Developer & Italian Press Contact[EMAIL PROTECTED]
>   The reverse side also has a reverse side.  -- Japanese proverb
--
--
http://www.kedai.com.my/kk
Am I Evil?


___
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] Virtual host admin under Apache+ZServer+SiteAccess

2000-06-02 Thread Shane Hathaway

J M Cerqueira Esteves wrote:
> 
> On Fri, Jun 02, 2000 at 09:02:11AM +0100, Phil Harris wrote:
> >
> > Try going to http://localhost:8080/__no_before_traverse__/manage
> >
> 
> Oops, I should have re-read SiteAccess docs...  Thanks.
> 
> After a few tests it seems to work normally except for one feature:
> 
> When managing through http://localhost:8080/manage I can see
> the full list of transactions with "Undo", but when managing through
> http://localhost:8080/__no_before_traverse__/manage, "Undo" only
> shows me the list of transactions made while operating that way
> (with __no_before_traverse__).  Usually not a problem... unless
> there are nasty side effects I am unaware of.

That's actually the exact problem I was working on yesterday.  I believe
we have solved it.  Stay tuned!

Shane
[EMAIL PROTECTED]

___
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] Aquisition questions

2000-06-02 Thread Shane Hathaway

Ian Sparks wrote:
> Is there a way to enforce URL's be traversed in a set way? Thus making :
> 
> mysite.com/Users/Fred/Flavor/Cherry/test
> 
> valid while mysite.com/Flavor/Cherry/Users/Fred/test becomes invalid.

You could set up an object called "Users" that would be found only if
the user goes through "Flavor" first.  Your example will have to be
modified to get it to work.

should work: mysite.com/Users/Fred/FlavorFolder/Flavor/Cherry/test

should not work: mysite.com/FlavorFolder/Flavor/Cherry/Users/Fred/test

FlavorFolder is a folder at the same level as Users.  It contains an SQL
query called Flavor and an object called Users.  The Users object in
this folder raises an exception, telling the clever user to back off.

Just a possibility.

> Also, assuming that both SQLMethods provide a "RowID", how do I specify
> explicitly which one I want, in OO terms :
> 
> Users.RowID or Flavor.RowID

Isn't there a way to cause the SQLMethods to provide "UserRowID" and
"FlavorRowID" instead?  That would be the most logical solution.

Shane

___
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] Virtual host admin under Apache+ZServer+SiteAccess

2000-06-02 Thread J M Cerqueira Esteves

On Fri, Jun 02, 2000 at 09:02:11AM +0100, Phil Harris wrote:
> 
> Try going to http://localhost:8080/__no_before_traverse__/manage
> 

Oops, I should have re-read SiteAccess docs...  Thanks.

After a few tests it seems to work normally except for one feature:

When managing through http://localhost:8080/manage I can see
the full list of transactions with "Undo", but when managing through 
http://localhost:8080/__no_before_traverse__/manage, "Undo" only 
shows me the list of transactions made while operating that way
(with __no_before_traverse__).  Usually not a problem... unless
there are nasty side effects I am unaware of.


 J Esteves (still a newbie in most Zopish matters...)

-- 
 jmce: +351 919838775 ~ http://artenumerica.com/ ~ http://artenumerica.org/

___
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] Two in one?

2000-06-02 Thread Andy Gates

> 

Ahh... quotes.  Parentheses.  Works a treat.  Ta.

AndyG

___
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] Two in one?

2000-06-02 Thread Andrew Kenneth Milton

+[ Andy Gates ]-
| Fun for all the family.  I'm trying to produce a page that draws from 
| two databases following one friendly search.  The first chunk of data 
| is from the search itself and returns, among others, an ID which I want
| to pass into the second chunk to search it.  Kinda like this:
| 
| Search page: blah
| 
| Report page: loop thru hits on "blah" in db1, any of 6 fields (name, 
| desc)
|   show id
|   show name
|   show desc...
|   loop thru hits in id db2
|   show users
|   show friendlynames
|   /loop
| /loop



-- 
Totally Holistic Enterprises Internet|  P:+61 7 3870 0066   | Andrew Milton
The Internet (Aust) Pty Ltd  |  F:+61 7 3870 4477   | 
ACN: 082 081 472 |  M:+61 416 022 411   | Carpe Daemon
PO Box 837 Indooroopilly QLD 4068|[EMAIL PROTECTED]| 

___
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] Two in one?

2000-06-02 Thread Andy Gates

Fun for all the family.  I'm trying to produce a page that draws from 
two databases following one friendly search.  The first chunk of data 
is from the search itself and returns, among others, an ID which I want
to pass into the second chunk to search it.  Kinda like this:

Search page: blah

Report page: loop thru hits on "blah" in db1, any of 6 fields (name, 
desc)
show id
show name
show desc...
loop thru hits in id db2
show users
show friendlynames
/loop
/loop

The problem I have is passing parameters to the db2 search.  Even if I 
set the SQL method to use a parameter with the same name as the var 
returned by the first search, I get a Zope error telling me I'm not 
passing enouh parameters to it.  Testing the methods independently they
work fine.

So, (as usual) what's the no-brain bozo error I'm making?  Is is 
possible to programmatically pass variables around like this (surely it
is,this would be trivial in ASP/JSP)?
--
Andy Gates, Learning and Research Technology
[EMAIL PROTECTED] - ICQ#74362415


___
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] Aquisition questions

2000-06-02 Thread Ian Sparks

Some time back I had an exchange with Mike Pelletier regarding SQL methods
and aquisition.

We talked about a URL structure :

mysite.com/Users/Fred/Flavor/Cherry/test

Users is a SQL method which takes a single parameter (value = Fred here).

Flavor is another method which takes a single parameters (value = Cherry
here).

test is a dhtml method which returns values pulled from the SQL methods.

I set this test up and it works fine.

One of the effects of aquisition is that the URLs :

mysite.com/Users/Fred/Flavor/Cherry/test
mysite.com/Flavor/Cherry/Users/Fred/test

are functionally identical in my simple DHTML test method but they might not
be, for instance if both SQLMethods provided a result column "RowID" then
 would contain the ID of whichever SQL method was run last.
Suddenly I'm getting a Users RowID when I expected a Flavor RowID.
Potentially disasterous.

Is there a way to enforce URL's be traversed in a set way? Thus making :

mysite.com/Users/Fred/Flavor/Cherry/test

valid while mysite.com/Flavor/Cherry/Users/Fred/test becomes invalid.

Also, assuming that both SQLMethods provide a "RowID", how do I specify
explicitly which one I want, in OO terms :

Users.RowID or Flavor.RowID

All help appreciated.

- Ian Sparks.












___
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] Using sql to search in zope

2000-06-02 Thread Graham Chiu

In article <93F7843B0CACD311A5320090271F3C224D7938@redlion2>, peter
<[EMAIL PROTECTED]> writes
>Where's the 'LIKE' ?

It's Access.

-- 
Regards,  Graham Chiu
gchiucompkarori.co.nz
http://www.compkarori.co.nz/index.php
Powered by Interbase and 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 )




Re: [Zope] Using sql to search in zope

2000-06-02 Thread Graham Chiu

In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes
>Hi All,
>
>I tried to build a search feature using sql in zope, this is what I normal
>do in sql to do a range search :
>
>select * from table1 where table1_id = %field1_value%

where table1_id =   


-- 
Regards,  Graham Chiu
gchiucompkarori.co.nz
http://www.compkarori.co.nz/index.php
Powered by Interbase and 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] Re: Fwd: [Zope] postgres DA

2000-06-02 Thread Bak @ kedai

> I can only say that we started writing PoPy and ZPoPyDA because pygresql
> (and the adapter based on it) are *not* thread safe. we were experimenting
> deadlocks in zope when you mix db access from sql methods and external
> methods in the same page.

quoting DAroadmap at 
http://www.zope.org/Members/petrilli/DARoadmap
"""

Level 2

Level 2 database adapters must be safe to use in a multi-threaded 
Zope instance. This can take multiple behaviour
paterns:

Internal locking/mutexes for single DA access

Global locking through the transaction manager if appropriate

While a sub-optimal solution, it should be usable on any 
application that has minimal, or infrequent, database access.
This means that all access paterns will be serialized.

In addition, all DAs at this level must release the Python global 
interpreter lock.
"""
i assume ZPoPyDA conform to the above statement.  will you make ZPoPyDa into
level 3 anytime soon?

> 
> on the other hand PoPy is pretty new and, before using it in production,
> needs more testing. i think it will stabilize pretty soon, because we will
> use it to build the web sites for our customers really soon now and that 
> will apport a lot of testing/debugging.
> 

i will try ZPoPyDA on my personal site, and will inform you of any
misbehaviour.  BTW, what symptoms should i look out for if ZPoPyDa misbehave? 
Zope locking/not responding?

 
>make your choice and be happy, 
made mine already, thanks, and 

"""
I'll be back!
"""


> federico
> 
> -- 
> Federico Di Gregorio
> MIXAD LIVE System Programmer   [EMAIL PROTECTED]
> Debian GNU/Linux Developer & Italian Press Contact[EMAIL PROTECTED]
>   The reverse side also has a reverse side.  -- Japanese proverb
-- 
--
http://www.kedai.com.my/kk
Am I Evil?


___
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] Using sql to search in zope

2000-06-02 Thread peter

Where's the 'LIKE' ?

Such as SELECT * FROM table1 WHERE table1_id LIKE %field1_value%

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]
Sent: 02 June 2000 09:10
To: [EMAIL PROTECTED]
Subject: [Zope] Using sql to search in zope


Hi All,

I tried to build a search feature using sql in zope, this is what I normal
do in sql to do a range search :

select * from table1 where table1_id = %field1_value%

But when I try it with zope, it will become

select * from table1 where table1_id = %'value'%

Which return an error : [ODBC Microsoft Access 97 Driver] Syntax error in
query expression 'table1_id alike %'field1_value'%'.")

Any idea or work around ??

Please help

Cheers

Wai


___
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] images in access database

2000-06-02 Thread peter

Is there a particular reason why you want to save the image _in_ the
database. Why not just save the name of the imagefile, its path, its width
and height etc. as text in an M$ Access database?
One advantage of that is that you can store a desciption (authorname, and
other info) together with the image entry.
You could then pull all of this out to create your own 

 


This can of course be made simpler and tweaked, maybe even through a Python
module.


Again; if you definitly want to save it as an OLE in Access, discard.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Terry
Kerr
Sent: 02 June 2000 04:44
To: [EMAIL PROTECTED]
Subject: [Zope] images in access database


Hi,

I would like to be able to have gifs/jpgs stored in an MS access
database and then pull the out using zope and display them in rendered
documents.  I am completely new to access.  I have successfully
installed the ODBCDA into zope, and are able to connect to an access
database and pull ordinary text data out of tables.

I have created a table in access with a column of type 'OLE object' and
put a gif image in as data.  This is the only way I know how to get an
image into the table.  The problem I think with this is that it is a
link to the gif on the HDD, and doesn't actually have the data in the
table?  Anyway, when I pull the data out of the table from zope, access
puts a header and footer around the gif binary data, and hence a simple
 wont work to display the image.  Has anyone else every
pulled images from an access database.  Will I have to write a method to
strip the header and footer from the returned data before displaying the
gif?

terry.

--
-
Terry Kerr ([EMAIL PROTECTED])
Adroit Internet Solutions
http://www.adroit.net/
03 9563 4461
0414 938 124



___
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] postgres DA

2000-06-02 Thread Bak @ kedai

On Fri, 02 Jun 2000, Stephan Richter wrote:
hi stephan!

> 
> I was just playing around with ZPoPyDA and PoPy (the Python module). It was 
> a little tricky to install, since the setup scripts are not fully automatic 
> yet, and the library header files did not point to my PostGres header files 
> directory. After the installation is done, everything worked like butter.
> Be sure to compile PostGres with multibyte support, since you may run in 
> troubles otherwise. The RPMs are compiled using that option.

i installed postgresql from RPM, so i guess that's ok.  i managed to install
ZPoPyDA, create a database connection, and do SQL stuff with no problems. 
sorry for my ignorance, but what is multibyte support,  and what kind of
problem one might run into if postgres was not compiled with multibyte support?

 > I am not able to evaluate ZPoPyDA at this point until I
haven't done some  > type testing and had the thread safety proof itself.

how do one test for thread safety level?  again, sorry for such obvious
question.

 > 
> Regards,
> Stephan
> --
> Stephan Richter
> CBU - Physics and Chemistry
> Web2k - Web Design/Development & Technical Project Management
-- 
--
http://www.kedai.com.my/kk
Am I Evil?


___
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] Thread-safe PostgreSQL adaptor?

2000-06-02 Thread Oleg Broytmann

On Fri, 2 Jun 2000, Daryl Tester wrote:
> >No - just using the GPL'd adapter do not require you to distribute Zope
> > under GPL. The adapter is just a "plugin"; there was an explanation from
> > RMS that GPL'd plugins does not require to GPL the main program and vice
> > versa; there probably will be newer version of GPL (don't know how soon)
> > which will explain the plugin thingie in details.
> > 
> >In short - only linking with GPL code "infects" your code with GPL.
> 
> This is unclear, and sounds like hair splitting to me.  What's the
> difference between linking and using a plugin?  What happens when
> the plugin is a dynamically linked shared library?  I haven't seen
> PoPy, but if it's a C library interface under Python (like Pygresql)
> the chances are good.

   These are perfect questions, and I knew RMS spent time thinking on it. I
am not authorized to answer; when (and if) new version of GPL will be
published I hope things will be clearer.

Oleg.(All opinions are mine and not of my employer)
 
Oleg Broytmann  Foundation for Effective Policies  [EMAIL PROTECTED]
   Programmers don't die, they just GOSUB without RETURN.


___
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] Re: Fwd: [Zope] postgres DA

2000-06-02 Thread Federico Di Gregorio

Scavenging the mail folder uncovered Paolo Comitini's letter:

> what's the current status of ZPygreSQLDA and ZPoPyDA? if i were to choose,
> which should i use?  and the reasons for using it?
> 
> i understand that ZPoPyDA is level 2 thread safety, and not quite sure what
> ZPygreSQLDA thread safety is.

I can only say that we started writing PoPy and ZPoPyDA because pygresql
(and the adapter based on it) are *not* thread safe. we were experimenting
deadlocks in zope when you mix db access from sql methods and external
methods in the same page.

on the other hand PoPy is pretty new and, before using it in production,
needs more testing. i think it will stabilize pretty soon, because we will
use it to build the web sites for our customers really soon now and that 
will apport a lot of testing/debugging.

make your choice and be happy,
federico

-- 
Federico Di Gregorio
MIXAD LIVE System Programmer   [EMAIL PROTECTED]
Debian GNU/Linux Developer & Italian Press Contact[EMAIL PROTECTED]
  The reverse side also has a reverse side.  -- Japanese proverb

___
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] postgres DA

2000-06-02 Thread Bak @ kedai

hi all,

what's the current status of ZPygreSQLDA and ZPoPyDA? if i were to choose,
which should i use?  and the reasons for using it?

i understand that ZPoPyDA is level 2 thread safety, and not quite sure what
ZPygreSQLDA thread safety is.

docs, pointers, explanation sought!

thanks

 -- 
--
http://www.kedai.com.my/kk
Am I Evil?


___
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] images in access database

2000-06-02 Thread Rik Hoekstra



>
>I would like to be able to have gifs/jpgs stored in an MS access
>database and then pull the out using zope and display them in rendered
>documents.  I am completely new to access.  I have successfully
>installed the ODBCDA into zope, and are able to connect to an access
>database and pull ordinary text data out of tables.
>
>I have created a table in access with a column of type 'OLE object' and
>put a gif image in as data.  This is the only way I know how to get an
>image into the table.  The problem I think with this is that it is a
>link to the gif on the HDD, and doesn't actually have the data in the
>table?  Anyway, when I pull the data out of the table from zope, access
>puts a header and footer around the gif binary data, and hence a simple
> wont work to display the image.  Has anyone else every
>pulled images from an access database.  Will I have to write a method to
>strip the header and footer from the returned data before displaying the
>gif?
>


Um, in general you'd have to have very strong reasons to put large objects
like images in a database (especially in Access). This has a negative effect
on the performance of your application as it adds to the overhead (putting
another layer between your webserver and your image retrieval). I don't see
what the gains would be.

If you consider putting image descriptions in your database, do so and no
more. Put the images on a filesystem somewhere and make your database
records point to them. This is much easier and much faster.

If the number of images is large you may have to do some thinking about the
directory structure.

hth

Rik


___
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] Using sql to search in zope

2000-06-02 Thread wai

Hi All,

I tried to build a search feature using sql in zope, this is what I normal
do in sql to do a range search :

select * from table1 where table1_id = %field1_value%

But when I try it with zope, it will become

select * from table1 where table1_id = %'value'%

Which return an error : [ODBC Microsoft Access 97 Driver] Syntax error in
query expression 'table1_id alike %'field1_value'%'.")

Any idea or work around ??

Please help

Cheers

Wai


___
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] Virtual host admin under Apache+ZServer+SiteAccess

2000-06-02 Thread Phil Harris

Jose,


Try going to http://localhost:8080/__no_before_traverse__/manage

hth

Phil
[EMAIL PROTECTED]

- Original Message -
From: "J M Cerqueira Esteves" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Jose Manuel Sebrosa" <[EMAIL PROTECTED]>
Sent: Friday, June 02, 2000 4:45 AM
Subject: [Zope] Virtual host admin under Apache+ZServer+SiteAccess


> On Thu, Jun 01, 2000 at 06:18:25PM -0600, ethan mindlace fremen wrote:
> > o Some basic hooks to support virtual hosting (a la
> >   SiteAccess) have been designed and will be added
> >   to allow product authors to write virtual hosting
> >   support without fragile dependencies on parts of
> >   the Zope core.
>
> Greetings
>
> For security reasons, I would like to do web administration of remote Zope
> installations via ssh port forwarding.  For instance, while running
>
>   ssh -g -L 8080:foo.bar:8080 foo.bar
>
> one can access a ZServer on foo.bar:8080 using  http://localhost:8080/.
>
> However, I'm using Apache with ZServer and SiteAccess for virtual
> hosting as documented in http://www.zope.org/Members/anser/apache_zserver,
> and this has a nasty implication: once I activate a SiteRoot inside some
> Zope folder "/parrot" for making it the top folder of a virtual host
> http://parrot.bar/, the use of URLs under http://parrot.bar/ is forced
> whenever administering content under the "/parrot" folder, even if
> arriving from a foo.bar:8080 document: the browser is then no longer
> connecting through the secure channel but talking directly with
> http://parrot.bar/.  Of course this could also be redirected, but not so
> easily.
>
> In this example, it would be nice to be able to administer the contents
> of http://parrot.bar/ either via parrot.bar (typically for less
> sensitive content, end users) or via foo.bar:8080 (more delicate
> administrative tasks, administrators which know how to encrypt
> communication with ssh).  Is there interest (or is it feasible) to make
> virtual hosting support evolve to allow this?  (I didn't think much
> about the implications, but can already notice a problem under the
> virtual hosting strategy above (ZServer+Apache): how to make Zope
> "guess" if it should write absolute URLs for parrot.bar or for
foo.bar:8080?)
>
> Even better would be web content administration under SSL, of course :)
>
>  jmce: +351 919838775 ~ http://artenumerica.com/ ~
http://artenumerica.org/
>
>
> ___
> 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] issue from this morning.

2000-06-02 Thread Marcus Collins

Hi,

> -Original Message-
> From: Patrick Keane [mailto:[EMAIL PROTECTED]]
> Sent: 01 June 2000 19:10
> To: [EMAIL PROTECTED]
> Subject: [Zope]   issue from this morning.
> 
> The problem is the order.
> 
> Netscape apparently likes to see URLS like
> 
> http://www.my.com/this.html#foo?var=data
> not
> http://www.my.com/this.html?var=data#foo
> 
> It chokes on the first, and is happy with the 2nd.  IE is happy with
> either.  Any chance this can be checked in as a revision to the tree
> code to be tested and confirmed?
> 
> PS - Which is the standard format of the two (as per ww3 or whatnot?)

Neither is "standard" per se -- RFC1808, which deals with URI's, says:

 "Note that the fragment identifier (and the "#" that precedes it) is
  not considered part of the URL.  However, since it is commonly used
  within the same string context as a URL, a parser must be able to
  recognize the fragment when it is present and set it aside as part of
  the parsing process."

However, the first form is recommended in the generic-RL syntax:

  :///;?#

and under Recommended Practices, so it would not be _recommended_ to change
the order, although it might be _desirable_

hth,

-- Marcus

___
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] Zope on Windows NT

2000-06-02 Thread brabander

One method that works is to change the port in z2.py.
cb

>= Original Message From Luis Cortes <[EMAIL PROTECTED]> =
>Hello,
>
>   Does anybody know how to change the Port that Zope uses on Windows NT
>when it is installed as a Service???  I know how to change it when it is
>installed as standalone - but that doesn't work when I run it as a service.
>
>
>Thanks for your help,
>Luis.
>



___
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 )