Re: Explicit SQL not working ...

2007-05-23 Thread ZebZiggle
Joseph ... you da man! Next time your in Halifax, Nova Scotia ... the beer is on me. I was looking at that method and ignored it since I'm not using transactions. THANK YOU! -Sandy --~--~-~--~~~---~--~~ You received this message because you are subscribed to t

Re: Explicit SQL not working ...

2007-05-23 Thread ZebZiggle
More info ... I wrote a little program to execute the query directly via psycopg and it works fine. Even if I take this test code and put it in the running django code, it continues to work fine. The SQL is an UPDATE command, like UPDATE content SET "vote

Re: Explicit SQL not working ...

2007-05-23 Thread ZebZiggle
More info ... I wrote a little program to execute the query directly via psycopg and it works fine. Even if I take this test code and put it in the running django code, it continues to work fine. The SQL is an UPDATE command, like UPDATE content SET "vote

Re: Explicit SQL not working ...

2007-05-23 Thread Joseph Heck
When you're done with the command (assuming you're not being explicit about the transactions), use: transaction.commit_unless_managed() to force the commit. -joe On 5/23/07, ZebZiggle <[EMAIL PROTECTED]> wrote: > > More info ... > > I wrote a little program to execute the query directly via p

Re: Explicit SQL not working ...

2007-05-23 Thread ZebZiggle
More info ... I wrote a little program to execute the query directly via psycopg and it works fine. Even if I take this test code and put it in the running django code, it continues to work fine. The SQL is an UPDATE command, like UPDATE content SET "vote

Re: Explicit SQL not working ...

2007-05-23 Thread ZebZiggle
More info ... I wrote a little program to execute the query directly via psycopg and it works fine. Even if I take this test code and put it in the running django code, it continues to work fine. The SQL is an UPDATE command, like UPDATE content SET "vote

Re: Explicit SQL not working ...

2007-05-23 Thread ZebZiggle
More info ... I wrote a little program to execute the query directly via psycopg and it works fine. Even if I take this test code and put it in the running django code, it continues to work fine. The SQL is an UPDATE command, like UPDATE content SET "vote

Explicit SQL not working ...

2007-05-23 Thread ZebZiggle
I'm doing a very simple direct SQL call cursor = connection.cursor() cursor.execute(sql) which works when I issue the SQL directly in the database, but via django does nothing. cursor.rowcount returns correctly, but there are no rows to fetch and the database isn't updated. Any ideas?