Τη Κυριακή, 27 Ιανουαρίου 2013 8:36:42 μ.μ. UTC+2, ο χρήστης Joel Goldstick
έγραψε:
> On Sun, Jan 27, 2013 at 1:05 PM, Κώστας Παπαδόπουλος <[email protected]>
> wrote:
>
> Τη Κυριακή, 27 Ιανουαρίου 2013 6:12:59 μ.μ. UTC+2, ο χρήστης [email protected]
> έγραψε:
>
>
>
>
> > 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]) )
This is not correct.
the <a href> attribute is for url (row[0]) only, not for url and hits too.
i want the following working code:
=============
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, url) )
print( "<td><b> %s </td>" % (hits) )
=============
inside the loop i posted initially, if its possible.
--
http://mail.python.org/mailman/listinfo/python-list