Re: [SQLObject] Traversing a table

2009-01-07 Thread Petr Jakeš
I don't think such a duplicity (to keep data in the database and some of rows in the text file) is the way to go. Try to use SQL distinct commands ( http://www.sqlobject.org/SelectResults.html#distinct) instead. It will offer unique rows from the database to your audience. Petr -

Re: [SQLObject] Traversing a table

2009-01-05 Thread Petr Jakeš
Hi, you are not telling us about columns. Are you trying to check if all collumns in the row are identical with some other row in the table? If yes, I would try to sort columns in the select. Than something like this can work (untested): counter=0 lastRow="" for actualRow in merge_table.select(ord

[SQLObject] Traversing a table

2009-01-05 Thread C Vora
Hi I'm somewhat new to Python and SQLObject (but have worked with ORM Wrappers before with Java). I have inherited a project which uses the above extensively. I have a somewhat novice question but couldn't find obvious answers so am posting here. So the code I have basically does a .select() on a