Formatting a column's value output

Joel Goldstick joel.goldstick at gmail.com
Sun Jan 27 13:36:42 EST 2013


On Sun, Jan 27, 2013 at 1:05 PM, Κώστας Παπαδόπουλος
<nikos.gr33k at gmail.com>wrote:

> Τη Κυριακή, 27 Ιανουαρίου 2013 6:12:59 μ.μ. UTC+2, ο χρήστης
> ru... at yahoo.com έγραψε:
> > On 01/27/2013 02:04 AM, Ferrous Cranus wrote:
> >
> > >[...]
> >
> > >             data = cur.fetchall()
> >
> > >             for row in data:
> >
> > >                     print ( "<tr>" )
> >
> > >
> >
> > >                     for item in row:
> >
> > >                             print( '''<td>  <a href='http://www.%s?show=log'>%s</a>
>  </td>''' % (item, item) )
> >
> > >[...]
> >
> > > Okey, so far BUT i want the url linking to happen only for the URL
> column's
> >
> > > value, and not for the hits column too. How do i apply the url link to
> the
> >
> > > URL column's value only?
> >
> >
> >
> > Ferrous,
> >
> >
> >
> > 'row' has two items (the url and the hit count) in it, right?
> >
> > So print each separately rather than in a loop:
> >
> >
> >
> >     data = cur.fetchall()
> >
> >     for row in data:
> >
> >       url = row[0]
> >
> >       hits = row[1]
> >
> >         print ( "<tr>" )
> >
> >         print( "<td>  <a href='http://www.%s?show=log'>%s</a>  </td>: %
> (url, hits) )
>
> Yes that can work, but i want to ask you if its possible to do the same
> thing from within the loop as i have it coded it until now.
>
> Is there a way to seperate the values within the loop?
>

for row in data:
    print( "<td>  <a href='http://www.%s?show=log'>%s</a>  </td>: " %
(row[0], row[1]) )

> --
> http://mail.python.org/mailman/listinfo/python-list
>



-- 
Joel Goldstick
http://joelgoldstick.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20130127/b62099cd/attachment.html>


More information about the Python-list mailing list