Re: Python - MySQL fetching values

2010-05-07 Thread Kurian Thayil
On Thu, May 6, 2010 at 2:42 PM, Chris Rebert wrote: > On Thu, May 6, 2010 at 1:47 AM, Kurian Thayil > wrote: > > > the expected output is 05:35:05. > > > > Now, here is code snippet, > > > > cursor1=getconnect1.cursor() > > getrows=cursor1.execute("""SELECT > > T

Re: Python - MySQL fetching values

2010-05-06 Thread Chris Rebert
On Thu, May 6, 2010 at 1:47 AM, Kurian Thayil wrote: > the expected output is 05:35:05. > > Now, here is code snippet, > >     cursor1=getconnect1.cursor() >     getrows=cursor1.execute("""SELECT > TIME(DATE_ADD(info_last_calltime, INTERVAL %s MINUTE)) FROM rem_call_info >

Python - MySQL fetching values

2010-05-06 Thread Kurian Thayil
Hi All, I am pretty new to python, and I have an issue with fetching values in python using MySQLdb module. The query executed is *SELECT TIME(DATE_ADD(info_last_calltime, INTERVAL %s MINUTE)) FROM rem_call_info WHERE info_ctrlid=%s""", (retryinterval,controlid1,)* where retryinterval=30 and cont