Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!weretis.net!feeder1.news.weretis.net!feeder4.news.weretis.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Newsgroups: comp.lang.python
Date: Sun, 27 Jan 2013 10:44:55 -0800 (PST)
In-Reply-To: <mailman.1116.1359311811.2939.python-list@python.org>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=94.68.70.179; posting-account=DYJQ-woAAACEPH85Au2BhUVfFTfSfVa4
References: <6ad78df4-0ec0-4760-8f5a-5ecf129c5e65@googlegroups.com> <mailman.1086.1359223462.2939.python-list@python.org> <d543dccf-af7a-4efd-adc5-13d9ef080c1e@googlegroups.com> <mailman.1090.1359239220.2939.python-list@python.org> <a8690843-35b0-423e-a79d-f2b6c1991be6@googlegroups.com> <63edba3c-55af-4c4c-a311-4188891bfdf0@googlegroups.com> <f0e08aad-3c69-4ba0-82d0-91652997c7d4@googlegroups.com> <mailman.1116.1359311811.2939.python-list@python.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Subject: Re: Formatting a column's value output
From: =?ISO-8859-7?B?yv7z9OHyINDh8OHk/PDv9evv8g==?= <nikos.gr33k@gmail.com>
To: comp.lang.python@googlegroups.com
Content-Type: text/plain; charset=ISO-8859-7
Content-Transfer-Encoding: quoted-printable
Cc: =?ISO-8859-7?B?yv7z9OHyINDh8OHk/PDv9evv8g==?= <nikos.gr33k@gmail.com>, "python-list@python.org" <python-list@python.org>
Precedence: list
Message-ID: <mailman.1118.1359312305.2939.python-list@python.org>
Lines: 146
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:37783

=D4=E7 =CA=F5=F1=E9=E1=EA=DE, 27 =C9=E1=ED=EF=F5=E1=F1=DF=EF=F5 2013 8:36:4=
2 =EC.=EC. UTC+2, =EF =F7=F1=DE=F3=F4=E7=F2 Joel Goldstick =DD=E3=F1=E1=F8=
=E5:
> On Sun, Jan 27, 2013 at 1:05 PM, =CA=FE=F3=F4=E1=F2 =D0=E1=F0=E1=E4=FC=F0=
=EF=F5=EB=EF=F2 <nikos...@gmail.com> wrote:
>=20
> =D4=E7 =CA=F5=F1=E9=E1=EA=DE, 27 =C9=E1=ED=EF=F5=E1=F1=DF=EF=F5 2013 6:12=
:59 =EC.=EC. UTC+2, =EF =F7=F1=DE=F3=F4=E7=F2 ru...@yahoo.com =DD=E3=F1=E1=
=F8=E5:
>=20
>=20
>=20
>=20
> > On 01/27/2013 02:04 AM, Ferrous Cranus wrote:
>=20
> >
>=20
> > >[...]
>=20
> >
>=20
> > > =A0 =A0 =A0 =A0 =A0 =A0 data =3D cur.fetchall()
>=20
> >
>=20
> > > =A0 =A0 =A0 =A0 =A0 =A0 for row in data:
>=20
> >
>=20
> > > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 print ( "<tr>" )
>=20
> >
>=20
> > >
>=20
> >
>=20
> > > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 for item in row:
>=20
> >
>=20
> > > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 print( '''<td=
> =A0<a href=3D'http://www.%s?show=3Dlog'>%s</a> =A0</td>''' % (item, item)=
 )
>=20
>=20
> >
>=20
> > >[...]
>=20
> >
>=20
> > > Okey, so far BUT i want the url linking to happen only for the URL co=
lumn's
>=20
> >
>=20
> > > value, and not for the hits column too. How do i apply the url link t=
o the
>=20
> >
>=20
> > > URL column's value only?
>=20
> >
>=20
> >
>=20
> >
>=20
> > Ferrous,
>=20
> >
>=20
> >
>=20
> >
>=20
> > 'row' has two items (the url and the hit count) in it, right?
>=20
> >
>=20
> > So print each separately rather than in a loop:
>=20
> >
>=20
> >
>=20
> >
>=20
> > =A0 =A0 data =3D cur.fetchall()
>=20
> >
>=20
> > =A0 =A0 for row in data:
>=20
> >
>=20
> > =A0 =A0 =A0 url =3D row[0]
>=20
> >
>=20
> > =A0 =A0 =A0 hits =3D row[1]
>=20
> >
>=20
> > =A0 =A0 =A0 =A0 print ( "<tr>" )
>=20
> >
>=20
> > =A0 =A0 =A0 =A0 print( "<td> =A0<a href=3D'http://www.%s?show=3Dlog'>%s=
</a> =A0</td>: % (url, hits) )
>=20
>=20
>=20
> Yes that can work, but i want to ask you if its possible to do the same t=
hing from within the loop as i have it coded it until now.
>=20
>=20
>=20
> Is there a way to seperate the values within the loop?
>=20
>=20
>=20
> for row in data:
>=20
> =A0 =A0 print( "<td> =A0<a href=3D'http://www.%s?show=3Dlog'>%s</a> =A0</=
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:

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
		data =3D cur.fetchall()
		for row in data:
			url =3D row[0]
			hits =3D row[1]
			print ( "<tr>" )
			print( "<td>  <a href=3D'http://www.%s?show=3Dlog'>%s</a>  </td>" % (url=
, url) )
			print( "<td><b> %s </td>" % (hits) )
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

inside the loop i posted initially, if its possible.