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

Groups > comp.lang.python > #56202

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

Show all headers | View raw

Στις 5/10/2013 7:08 μμ, ο/η Ned Batchelder έγραψε:
>
> 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.


cookieID = cookie.get('ID').value

is not returning what you said it will return

and if cookie.get('ID') doenst exist it returns the error 
AttributeError: 'NoneType' object has no attribute 'value'

These are 2 problem.

value aint being returned thw ehole Set-Cookie: ID=some_number is being 
returned instead as tou cna see at http://superhost.gr/

and the second problem is

that if the cookie dosnt exist i get the error of: AttributeError: 
'NoneType' object has no attribute 'value'

whne this line is tryign to be executed:
cookieID = cookie.get('ID').value

How can i deal with thse 2 problems?

-- 
What is now proved was at first only imagined! & WebHost
<http://superhost.gr>

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