[Zope] ZSQL ? PoPy

2000-10-31 Thread Mark Twiddy

Hi all

Can someone please tell me what is going on here?

I have an query that selects data into a temp table.
It then deletes some stuff from the temp table
Then is deletes some more stuff 
Then i select the remaining records and drop the table

The problem is that when i try to select the remaining records it just
hangs. I do a ps on this i and i can see the query is running but it just
does not return anything and fills up disk.

I am using PoPy 1.4 Postgres  6.5.1 on i386-unknown-freebsd2.2.7, compiled
by gcc 2.7.2.1]

any clues


Thanks Mark


___
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] PoPy

2000-10-29 Thread Mark Twiddy

Hi all 

Im trying to compile PoPy on a bsd 3.1 box it compiles fine but when
i try to import it i get an error 

ImportError: ./PoPymodule.so: Undefined symbol "sem_wait"

Has anybody had this before, know what libs i need to link against to
get this to work or even if this is  a kernel thing?

Thanks Mark


___
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] Zope python 2

2000-10-25 Thread Mark Twiddy

Hi all

Is anyone using or know the current state of Zope with python 2.0 ?

Thanks

Joe


___
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-sqlvar quote

2000-10-19 Thread Mark Twiddy


Hi all

How can i pass a string to a sql method that won't be quoted.

i.e so i can do somthing like this

.
group by foo,blah
order by dtml-sqlvar spam


thanks mark
 


___
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] submit buttons

2000-10-19 Thread Mark Twiddy

Hi all

I can remember reading but can't remember where or how ,another way to
submit forms .
somthing like

form


input type=submit name=spam value=blah some action here
/form

does anyone have an example 

thanks again
Mark


___
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-let ?

2000-10-11 Thread Mark Twiddy

hi all
Sorry fro the dumb question.
Im totaling columns returned from a zsql thingy is there an easy way to do
this in dtml.

thanks
mark


___
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] locking help

2000-10-10 Thread Mark Twiddy


Hi,

Can someone please tell me what is going on. while querying a postgres
database i am unable to access any crap from zope. I have tried creating a
db connection in a enternal method and querying through that but it still 
locks and wont serve any requests.

a

Mark


___
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] locking help

2000-10-10 Thread Mark Twiddy


Hi thanks for the reply
The problem is whenever i do really big query everything stops and waits.

im using
ZPyGreSQLDA-0.3-rjr2
and 
py-PyGreSQL-2.4

thanks 
Mark
On Tue, 10 Oct 2000, Mike Renfro wrote:

 On Tue, Oct 10, 2000 at 04:58:46PM +0930, Mark Twiddy wrote:
 
  Can someone please tell me what is going on. while querying a
  postgres database i am unable to access any crap from zope. I have
  tried creating a db connection in a enternal method and querying
  through that but it still locks and wont serve any requests.
 
 Don't know if this will help, but my Zope/Postgresql experience has
 gone remarkably well.
 
 I have the following packages installed on an otherwise regular Debian
 2.2 machine:
 
 libpgsql2 7.0.2-6 Shared library libpq.so.2 for PostgreSQL
 postgresql7.0.2-6 Object-relational SQL database, descended fr
 postgresql-client 7.0.2-6 Front-end programs for PostgreSQL
 postgresql-dev7.0.2-6 Header files for libpq (postgresql library)
 postgresql-doc7.0.2-6 Documentation for the PostgreSQL database.
 python-pygresql   7.0.2-6 PostgreSQL module for Python
 zope  2.2.2-1 The Z Object Publishing Environment
 zope-pygresqlda   0.3rjr2-1   A Zope Database Adapter for PostgreSQL
 
 Between those packages, following the PostgreSQL tutorial at
 postgresql.org, and following the Z SQL Methods User's Guide
 (http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.html), I'm
 working fine. Where are the actual errors?
 
 -- 
 Mike Renfro  / RD Engineer, Center for Manufacturing Research,
 931 372-3601 / Tennessee Technological University -- [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 )




Re: [Zope] locking help

2000-10-10 Thread Mark Twiddy

Hi all,

Thanks for all the help

Ive installed PoPy-1.36 and ZPoPyDA-0.64 and it works like a bastard :

Thanks all
Mark

On Wed, 11 Oct 2000, Philipp Auersperg wrote:

 this Postgres adapter is not multithreaded, check out the ZPoPyDA from zope.org. 
 That is an alternative Postgres adapter that is multithreaded and does not lock up.
 
 phil
 *** REPLY SEPARATOR  ***
 
 On 11.10.2000 at 08:48 Mark Twiddy wrote:
 
 Hi thanks for the reply
 The problem is whenever i do really big query everything stops and waits.
 
 im using
 ZPyGreSQLDA-0.3-rjr2
 and 
 py-PyGreSQL-2.4
 
 thanks 
 Mark
 On Tue, 10 Oct 2000, Mike Renfro wrote:
 
  On Tue, Oct 10, 2000 at 04:58:46PM +0930, Mark Twiddy wrote:
  
   Can someone please tell me what is going on. while querying a
   postgres database i am unable to access any crap from zope. I have
   tried creating a db connection in a enternal method and querying
   through that but it still locks and wont serve any requests.
  
  Don't know if this will help, but my Zope/Postgresql experience has
  gone remarkably well.
  
  I have the following packages installed on an otherwise regular Debian
  2.2 machine:
  
  libpgsql2 7.0.2-6 Shared library libpq.so.2 for PostgreSQL
  postgresql7.0.2-6 Object-relational SQL database, descended fr
  postgresql-client 7.0.2-6 Front-end programs for PostgreSQL
  postgresql-dev7.0.2-6 Header files for libpq (postgresql library)
  postgresql-doc7.0.2-6 Documentation for the PostgreSQL database.
  python-pygresql   7.0.2-6 PostgreSQL module for Python
  zope  2.2.2-1 The Z Object Publishing Environment
  zope-pygresqlda   0.3rjr2-1   A Zope Database Adapter for PostgreSQL
  
  Between those packages, following the PostgreSQL tutorial at
  postgresql.org, and following the Z SQL Methods User's Guide
  (http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.html), I'm
  working fine. Where are the actual errors?
  
  -- 
  Mike Renfro  / RD Engineer, Center for Manufacturing Research,
  931 372-3601 / Tennessee Technological University -- [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 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] Anonymous logins

2000-10-09 Thread Mark Twiddy

Hi all

How can i restrict Anonymous logins to a domain.

Thanks
Mark


___
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] Login Manager

2000-10-08 Thread Mark Twiddy

Hi

I've been tring to install Login Manager. I installed ZPattens ok and it
works but i am unable to get login manager going.

file "/home/markt/Zope/lib/python/Products/LoginManager/LoginManager.py",
line 9, in ?
from Products.ZPatterns.SheetProviders import SheetProviderContainer
ImportError: cannot import name SheetProviderContainer


any help would be great

Thanks 
Mark


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