On Tue, Oct 26, 2010 at 9:00 PM, sanmugam k <[email protected]> wrote:

> Bit of python code:
>
>        print self.cou
>        disp=cur.execute("""select * from sales offset(select count(*)%d
> from sales);""" %self.cou)
>        print disp
>        print type(disp)
>

See if 'query' here and the SQL statement in your PSQL prompt match

query = "select * from sales offset(select count(*)%d..... blah blah
print query
disp = cur.execute(query)
...
...

Its mostly likely that you are executing the wrong query.
-- 
Sudharshan S
http://sudharsh.wordpress.com
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc

Reply via email to