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

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

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

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