[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

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

Re: [Zope] Z SQL Method question

2006-06-03 Thread Infor Gates
call write_user(field_id,field_voornaam,field_acyternaam Can you help me withe the next step I't the first time that 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

Re: [Zope] Z SQL Method question

2006-05-29 Thread Martin Koekenberg
SQL 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 assumption based on dtml. In

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 really

[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 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

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. form action=optional_path_to/some_method ... The dtml method should have a call to your Z SQL Method dtml-call my_sql_method And then you can add

[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: dtml-in sql_example dtml-call "REQUEST.set('my_var', result)" /dtml-in This works fine.But should

Re: [Zope] Z SQL Method

2001-01-30 Thread Diego Rodrigo Neufert
maybe dtml-call "REQUEST.set('my_var', _['sql_example'])" 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