Re: [Zope] Z SQL Method properties

2007-02-13 Thread Andrew Milton
+---[ David VanKirk ]-- | Does anyone know of a way that I can write a script to traverse | through a folder of Z SQL Methods and find out the connection ID for | each? for o in container.objectValues(['Z SQL Method',]): print o.id, o.connection_id return printed --

[Zope] Z SQL Method properties

2007-02-13 Thread David VanKirk
Does anyone know of a way that I can write a script to traverse through a folder of Z SQL Methods and find out the connection ID for each? Reason being, I have two connections objects for my ZSQL Methods to use. I'm trying to phase out the one and I'd like to write a script to tell me which ZSQL

Re: [Zope] Z SQL Method question

2006-06-03 Thread Infor Gates
t I use MySQL/Zope and Z MySQL Method.   Regards,   Martin Koekenberg -Original Message-From: Thomas Bennett <[EMAIL PROTECTED]>To: zope@zope.orgDate: Fri, 26 May 2006 09:16:24 -0400Subject: Re: [Zope] Z SQL Method question With a lack of information here I'll answer based fully on as

Re: [Zope] Z SQL Method question

2006-05-29 Thread Dieter Maurer
Martin Koekenberg wrote at 2006-5-29 15:24 +0200: > ... >Now the following >I submit a form (build with formulator). >The action point to a dtml Method witch calls the above Z MySQL Method >(dtml-call write_user). > >Nothing is happening If really nothing happens, then you do not real

Re: [Zope] Z SQL Method question

2006-05-29 Thread Martin Koekenberg
Message-From: Thomas Bennett <[EMAIL PROTECTED]>To: zope@zope.orgDate: Fri, 26 May 2006 09:16:24 -0400Subject: Re: [Zope] Z SQL Method question With a lack of information here I'll answer based fully on assumption based on dtml.  In your form the action should go to a dtml method. T

Re: [Zope] Z SQL Method question

2006-05-26 Thread Thomas Bennett
With a lack of information here I'll answer based fully on assumption based on dtml. In your form the action should go to a dtml method. The dtml method should have a call to your Z SQL Method And then you can add anything in the dtml method which will be viewed as the response page to t

Re: [Zope] Z SQL Method question

2006-05-26 Thread Andreas Jung
--On 26. Mai 2006 14:54:58 +0200 Martin Koekenberg <[EMAIL PROTECTED]> wrote: Hello, Who has experience with Z SQL Method. I Created a from to enten some data into MySQL server. I used Z SQL Method to write the dat into the databse. Everytime I submit the form I get a screen with the fie

[Zope] Z SQL Method question

2006-05-26 Thread Martin Koekenberg
  Hello,   Who has experience with Z SQL Method. I Created a from to enten some data into MySQL server. I used Z SQL Method to write the dat into the databse. Everytime I submit the form I get a screen with the field in my Z SQL Method component.   How can I write the dat from a form into

Re: [Zope] Z SQL Method

2001-01-30 Thread Diego Rodrigo Neufert
maybe works On Tuesday 30 January 2001 12:22 pm, Martin Jundt wrote: > Hi there, > > I have got a litte problem with a Z SQL Method "sql_example": > > select count(*) as result from example_DB > > I want to put the returned result in a variable: > > > > > > This w

[Zope] Z SQL Method

2001-01-30 Thread Martin Jundt
Hi there, I have got a litte problem with a Z SQL Method "sql_example": select count(*) as result from example_DB I want to put the returned result in a variable: This works fine.But should something like work, too? Thanks Martin

Re: [Zope] Z SQL Method

2000-07-06 Thread Richard Moon
On Wed, 5 Jul 2000, Paul Aviles wrote: > > What am I doing wrong?? Also, is there a way to connect to a postgres or > mysql database? Is one better than the other? Postgresql is a true object relational database which includes the ability to define transactions etc., MySQL isn't a true RDBMS.