Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #56201

Re: Select fails when cookie tried to get a numeric value

Show key headers only | View raw

On 10/5/13 11:52 AM, Νίκος Αλεξόπουλος wrote:
> Στις 5/10/2013 6:12 μμ, ο/η Ned Batchelder έγραψε:
>> On 10/5/13 10:40 AM, Νίκος Αλεξόπουλος wrote:
>>> Στις 5/10/2013 4:53 μμ, ο/η Ned Batchelder έγραψε:
>>>
>>>>  From reading the bottom-most frame, you can see that the problem is
>>>> that "val" is an http.cookies.Morsel object.  This means you probably
>>>> tried to use a cookie object as data in your SQL query, and MySQL
>>>> doesn't know what to do with that object.  You'll have to use a more
>>>> primitive piece of data in your query.
>>>
>>> # initialize cookie
>>> cookie = cookies.SimpleCookie( os.environ.get('HTTP_COOKIE') )
>>> cookie.load( cookie )
>>> cookieID = cookie.get('ID')
>>>
>>> # if browser cookie does not exist, set it
>>> if not cookieID:
>>>     cookie['ID'] = random.randrange(0, 10000)
>>>     cookie['ID']['path'] = '/'
>>>     cookie['ID']['expires'] = 60*60*24*365        #this cookie will
>>> expire in a month
>>>     cookieID = cookie.get('ID')
>>>     print( cookie )
>>>
>>>
>>> In the above code i try to retrive the cookie form the visitor's
>>> browser and if it does nto exist i create one.
>>>
>>>
>>>
>>> For some reason i think CookieID nevers gets inserted itnot the
>>> database that's why mysql's select statemnt fails.
>>>
>>> When i print CookieID i was under the impression i would see a random
>>> number like '5369' but instead it display the follwong.
>>>
>>> Set-Cookie: ID="Set-Cookie: ID=5369"
>>>
>>> The mysql filed CookieID is of datatype's int(5) so it cannto store
>>> this value.
>>>
>>> If iam correct and thi is trully the problem then how can i just get
>>> the random number part out the whole string?
>>>
>>> Do you see something wrong?
>>> Why cookie['ID'] retuned this string back and not just the number?
>>>
>>>
>>
>> Thanks for being patient.  Where you have this:
>>
>>      cookieID = cookie.get('ID')
>>
>> you actually want this:
>>
>>      cookieID = cookie.get('ID').value
>>
>> --Ned.
>
>
> [Sat Oct 05 15:51:02 2013] [error] [client 108.162.229.114]   File 
> "/home/nikos/public_html/cgi-bin/metrites.py", line 84, in <module>
> [Sat Oct 05 15:51:02 2013] [error] [client 108.162.229.114] cookieID = 
> cookie.get('ID').value
> [Sat Oct 05 15:51:02 2013] [error] [client 108.162.229.114] 
> AttributeError: 'NoneType' object has no attribute 'value'
>

Nikos: you know enough to understand what is going on here.

This list will not serve you well if you take every error message and 
paste it into an email without trying to get to the bottom of it 
yourself.  At the very least, a Google search on, "AttributeError: 
'NoneType' object has no attribute 'value'" will find you some answers.

I've said it before, I'll say it again:  slow down.

--Ned.

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 16:38 +0300
  Re: Select fails when cookie tried to get a numeric value Ned Batchelder <ned@nedbatchelder.com> - 2013-10-05 09:53 -0400
    Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 17:40 +0300
      Re: Select fails when cookie tried to get a numeric value Ned Batchelder <ned@nedbatchelder.com> - 2013-10-05 10:54 -0400
      Re: Select fails when cookie tried to get a numeric value Ned Batchelder <ned@nedbatchelder.com> - 2013-10-05 11:12 -0400
        Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 18:31 +0300
          Re: Select fails when cookie tried to get a numeric value Andreas Perstinger <andipersti@gmail.com> - 2013-10-05 17:47 +0200
          Re: Select fails when cookie tried to get a numeric value Chris Angelico <rosuav@gmail.com> - 2013-10-06 09:36 +1100
        Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 18:52 +0300
          Re: Select fails when cookie tried to get a numeric value Ned Batchelder <ned@nedbatchelder.com> - 2013-10-05 12:08 -0400
            Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 19:14 +0300
              Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 19:17 +0300
                Re: Select fails when cookie tried to get a numeric value Ned Batchelder <ned@nedbatchelder.com> - 2013-10-05 12:42 -0400
                Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 19:53 +0300
      Re: Select fails when cookie tried to get a numeric value Zero Piraeus <z@etiol.net> - 2013-10-05 12:06 -0300
        Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 18:50 +0300
  Re: Select fails when cookie tried to get a numeric value Chris Angelico <rosuav@gmail.com> - 2013-10-05 23:59 +1000
    Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 17:24 +0300
      Re: Select fails when cookie tried to get a numeric value Chris Angelico <rosuav@gmail.com> - 2013-10-06 00:28 +1000
        Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 17:30 +0300
          Re: Select fails when cookie tried to get a numeric value Ned Batchelder <ned@nedbatchelder.com> - 2013-10-05 10:43 -0400
            Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 17:47 +0300
          Re: Select fails when cookie tried to get a numeric value Zero Piraeus <z@etiol.net> - 2013-10-05 11:44 -0300
          Re: Select fails when cookie tried to get a numeric value MRAB <python@mrabarnett.plus.com> - 2013-10-05 17:51 +0100
      Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 17:28 +0300
      Re: Select fails when cookie tried to get a numeric value Andreas Perstinger <andipersti@gmail.com> - 2013-10-05 18:56 +0200
        Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 20:38 +0300
  Re: Select fails when cookie tried to get a numeric value Benjamin Rovny <rdr.vladimir@gmail.com> - 2013-10-05 09:35 -0500
  Re: Select fails when cookie tried to get a numeric value Terry Reedy <tjreedy@udel.edu> - 2013-10-05 18:06 -0400
  Re: Select fails when cookie tried to get a numeric value Denis McMahon <denismfmcmahon@gmail.com> - 2013-10-05 23:36 +0000
    Re: Select fails when cookie tried to get a numeric value Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-06 08:20 +0300
      Re: Select fails when cookie tried to get a numeric value Denis McMahon <denismfmcmahon@gmail.com> - 2013-10-06 14:57 +0000
      Re: Select fails when cookie tried to get a numeric value Piet van Oostrum <piet@vanoostrum.org> - 2013-10-06 22:16 -0400

csiph-web