how to manage CLOB type with cx_oracle

Hi, I need to read CLOB field type (it is long text) if I use this code: curs.execute(sqlstr) rows['name_of_columns'] = name_of_columns rows['data'] = curs.fetchall() it returns me this values: test = {'name_of_columns': ['FILENAME', 'CRONTIME', 'SHORT_TAIL', 'L

Re: how to manage CLOB type with cx_oracle

On Mar 3, 1:01 pm, Loredana wrote: > Hi, > > I need to read CLOB field type (it is long text) > > if I use this code: > > curs.execute(sqlstr) > rows['name_of_columns']     =   name_of_columns > rows['data']                         =   curs.fet

Re: how to manage CLOB type with cx_oracle

On Mar 3, 5:12 pm, "Gabriel Genellina" wrote: > En Tue, 03 Mar 2009 13:33:19 -0200, Loredana   > escribió: > > > > > > > On Mar 3, 1:01 pm, Loredana wrote: > >> Hi, > > >> I need to read CLOB field type (it is long text) > &

The fastest way to convert a long list of date

;2008-09-28’, '2008-09-29’,.] to [’26 sep’,’28 sep’,’29 sep’,] Thank you Loredana -- http://mail.python.org/mailman/listinfo/python-list

Re: The fastest way to convert a long list of date

9’ is missing and I want to append the value ['2009:01:29’,0] to rows [‘Label’]) 2) convert the date format (for example in '%A %d, %b %y') 3) transform rows dictionary in JSON code The point 3) is easy to implement but I’m wondering which is the best way to implement the point 1) and 2) ...considering it will be used for a web application (CherryPy)? thanks, Loredana -- http://mail.python.org/mailman/listinfo/python-list