[Tutor] postgreSQL + psycopg2

[nitin chandra]

IT WORKED !!!!

THANK YOU SSSOOOO MUCH ...phew .. Thank you

here is the result.

1
('Supervisor',)
<tr>
<td>1</td>
<td>Vinayak</td>
<td>Salunke</td>
<td>1</td>

Now I need to remove the braces and quotes .. :)

Thank you

Nitin

On 10 May 2016 at 12:30, Peter Otten <__peter__ at web.de> wrote:
> nitin chandra wrote:
>
>> Thanks Alan, Peter
>>
>> but didn't work
>>
>>     nextrow=(cursor1.execute(query, (design1,))).fetchone()
>> AttributeError: 'NoneType' object has no attribute 'fetchone'
>
> Try without the method chaining:
>
> cursor1.execute(query, (design1,))
> nextrow = cursor1.fetchone()
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> To unsubscribe or change subscription options:
> https://mail.python.org/mailman/listinfo/tutor