[Zope] DateTime problem

[Alejandro Pancani]

if I have a string that represent a date with the format dd/mm/
How could I do to obtain a DateTime object from it?


Alejandro Pancani
[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] Problen wtih dtml-in inside Zsql method

[Alejandro Pancani]

-
I have a problem using a 'dtml-in' tag inside of  a Zsql method and I'm
wondering if anybody can help me

I´m using a sequence  in  ORACLE  (called 'seq')  and I need to obtain the
following value of that sequence before execute other Zsql methods.
For that, I define a  Zsql method (called sql_select_nextval) that returns
the following  value of the sequence and other Zsql method (called sql_2 )
that executes another actions. The problem is that when I execute the Zsql
method 'sql_2' it seems to execute the sql_select_next_val method two times
because at the next time that I execute 'sql_2'  the value returned from
sql_select_next_val is incremented in 2 in comparison with last value
returned. I need it to be incremented in 1.



the code of  sql_select_nextval method is the following:

 SELECT seq.NEXTVAL  val
   FROM DUAL


the code of sql_2  method is the following:

dtml-in "sql_select_nextval"

insert into anytable
(oid_anytable, name)
values
 (dtml-var val,
  'john')

   dtml-var sql_delimiter

select * from anytable  where oid_anytable  = dtml-var val

/dtml-in

The code used to create the sequence is the following:

CREATE SEQUENCE seq
 START WITH 1
 NOCYCLE
NOCACHE;



Note: if I put the dtml-in outside of the Zsql method it seems to work
correctly...




Alejandro Pancani
[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] Stored Procedures

[Alejandro Pancani]

Hi 
I´m using Zope with an Informix Database conected 
with ZODBC Product and I need some information about how to call a STORED 
PROCEDURE
I´m trying to call a STORED PROCEDURE that executes 
a simple query. I do it usinga ZSQL method, but when i try to test it, i 
receive the error message "empty column name".Does anybody have any 
information about that problem?

[Zope] STORED PROCEDURES

[Alejandro Pancani]

Hi
I´m using Zope with an Informix Database conected with ZODBC Product and I
need some information about how to call a STORED PROCEDURE
I´m trying to call a STORED PROCEDURE that executes a simple query. I do it
using a ZSQL method, but when i try to test it, i receive the error message
"empty column name". Does anybody have any information about that problem?


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