Formatting a column's value output
Virgil Stokes
vs at it.uu.se
Sun Jan 27 12:46:24 EST 2013
On 27-Jan-2013 17:12, rurpy at yahoo.com wrote:
> 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) )
It is nice to see some constructive feedback to Ferrous from the python-list.
This will hopefully help to get Ferrous on the right track.
More information about the Python-list
mailing list