Python

newb: Print ids, you get 1L, what is L?

•

Join Date: Jan 2007

Posts: 58

Reputation: jobs is an unknown quantity at this point

Solved Threads: 0

jobs

Offline

Junior Poster in Training

newb: Print ids, you get 1L, what is L?

Sep 14th, 2007

When I execute the following sql,select id from people, inside python and print the result, I get this:

((11L,), (12L,), (13L,), (14L,), (15L,), (16L,), (17L,), (18L,), (19L,), (20L,))

Why does python print L beside the numbers. Just to indicate Long type?

•

Join Date: Jul 2006

Posts: 608

Reputation: jrcagle is on a distinguished road

Solved Threads: 152

jrcagle

Offline

Practically a Master Poster

Re: newb: Print ids, you get 1L, what is L?

Sep 14th, 2007

Apparently so. You can check it:

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
>>> a =  ((11L,), (12L,), (13L,), (14L,), (15L,), (16L,), (17L,), (18L,), (19L,), (20L,))
>>> print a[0]
(11L,)
>>> print a[0][0]
11
>>> print type(a[0][0])
<type 'long'>
>>>
>>> a =  ((11L,), (12L,), (13L,), (14L,), (15L,), (16L,), (17L,), (18L,), (19L,), (20L,))
>>> print a[0]
(11L,)
>>> print a[0][0]
11
>>> print type(a[0][0])
<type 'long'>
>>>

Jeff

•

Join Date: Sep 2007

Posts: 33

Reputation: paddy3118 is an unknown quantity at this point

Solved Threads: 9

paddy3118

Offline

Light Poster

Re: newb: Print ids, you get 1L, what is L?

Sep 15th, 2007

If you are returning longs you can selectively turn them into integers using int() e.g:

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
>>> a =  ((11L,), (12L,), (13L,), (14L,), (15L,), (166666666666L,))
>>> b = tuple((int(i[0]),) for i in a)
>>> b
((11,), (12,), (13,), (14,), (15,), (166666666666L,))
>>>
>>> a =  ((11L,), (12L,), (13L,), (14L,), (15L,), (166666666666L,))
>>> b = tuple((int(i[0]),) for i in a)
>>> b
((11,), (12,), (13,), (14,), (15,), (166666666666L,))
>>>

- Paddy.