On 06/07/2013 01:44 PM, ethereal_r...@hotmail.com wrote:
<SNIP>
rows = cur.fetchall()
for row in rows:
print row
Now assume that fetchall would print the following:
I doubt if fetchall() prints anything. presumably it returns something,
extracted from the db.
LOEL910624ND5 from the column vat as RFC.
227 from the column amount_untaxed.
Now I would need to print that in the following format.
04|85|LOEL910624ND5|||||227|||||||||||||||
04 always goes in the first column and 85 always goes in the second, vat goes
in the third and the amount_untaxed goes in the eight column but we still need
to have 22 columns in total.
I don't use psycopg2, and I'd suggest few others here do either.
Since the problem has nothing to do with psycopg2, could you simplify
the problem? Whatever fetchall() returns, it's presumably either a dict
or list. Or is it a list of lists?
Find out what kind of data it is, and stub it with something like:
rows = ["ab", "127"]
Then if you define what the items in that list (or whatever) are
supposed to mean, we can tell you how to stick all those pipe-symbols
between. One likely answer would be the csv module.
--
DaveA
--
http://mail.python.org/mailman/listinfo/python-list
