Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!rt.uk.eu.org!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Sender: Ned Batchelder <nedbat@gmail.com>
Date: Sat, 05 Oct 2013 11:12:42 -0400
From: Ned Batchelder <ned@nedbatchelder.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:17.0) Gecko/20130801 Thunderbird/17.0.8
MIME-Version: 1.0
To: =?UTF-8?B?zp3Or866zr/PgiDOkc67zrXOvs+Mz4DOv8+FzrvOv8+C?= <nikos.gr33k@gmail.com>
Subject: Re: Select fails when cookie tried to get a numeric value
References: <l2p4o4$4ht$1@dont-email.me> <mailman.743.1380981201.18130.python-list@python.org> <l2p8cl$j06$4@dont-email.me>
In-Reply-To: <l2p8cl$j06$4@dont-email.me>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Cc: python-list@python.org
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.748.1380985965.18130.python-list@python.org>
Lines: 57
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:56194

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.