Ah great!!!
I just examined my other MySQL database which just stored webpages and
their corresponding visits and voila.
Someone was able to pass values into my counters table:
look:
http://superhost.gr/?show=stats
thats why it didn't had 1 or 2 or 3 as 'counterID' but more values were
pre
I have decided to take your advice.
I wasn't able to fit those 'lists' of mine into MySQL's varchar()
datatype after converting them to long strings and that sads me.
My implementation is like the following.
I do not use an extra table of downlaods that i asoociate with table
visitors with a f
Ok, that seems to work... I modified from another package.
I don't understand how setup.py does it exactly, but got it done anyways.
--
https://mail.python.org/mailman/listinfo/python-list
nope there is no installation instructions
--
https://mail.python.org/mailman/listinfo/python-list
On 5 Nov 2013 15:30:19 GMT, Neil Cerutti wrote:
On 2013-11-05, Dave Angel wrote:
> On Tue, 05 Nov 2013 16:32:57 +0330, Mohsen Pahlevanzadeh
>> May be it initialized with myVar = u'x' or myVar = 'x'
My solution assumed he wanted to distinguish between those two cases.
>> So i need determine
On Tue, 5 Nov 2013 17:51:00 -0800 (PST), chovd...@gmail.com wrote:
result += ((-1) ** (k+1))/2*k-1
One of two things are happening here. Maybe both.
You're using Python 2.x (and should havesaid so) where integer
division is truncated.
You're missing around some part of the intende
On Tue, 5 Nov 2013 09:45:15 -0600, Tim Chase
wrote:
You're assigning it to the bound function rather than calling the
function. Use the "call" operator:
data = infile.readlines()
Thanks for spoiling the lesson. Nicks needs to learn how to debug 4
line programs without someone giving him
On 11/05/2013 02:07 AM, Antoon Pardon wrote:
And now you have depraved Nikos of the opportunity to really learn
something. ...
I know you meant "deprived", but "depraved Nikos" sounds like a good
description to me. ;-)
-=- Larry -=-
--
https://mail.python.org/mailman/listinfo/python-
On Tue, 05 Nov 2013 17:51:00 -0800, chovdary wrote:
> Hi friends
>
> help me with the following code. Im able to execute the code but getting
> wrong output
[snip code]
You have this critical expression in your code:
result += ((-1) ** (k+1))/2*k-1
It looks to me like you are using Python 2
On 06/11/2013 01:51, chovd...@gmail.com wrote:
Hi friends
help me with the following code. Im able to execute the code but getting wrong
output
def sequence_b(N):
N = 10
result = 0
for k in xrange (1,N):
result += ((-1) ** (k+1))/2*k-1
print result
print sequ
chovd...@gmail.com writes:
> def sequence_b(N):
> N = 10
> result = 0
> for k in xrange (1,N):
> result += ((-1) ** (k+1))/2*k-1
Every number here is an integer. Python 2 will keep all the computations
integers by default::
$ python2
>>> 1 / 2
0
You want to use
Hi friends
help me with the following code. Im able to execute the code but getting wrong
output
def sequence_b(N):
N = 10
result = 0
for k in xrange (1,N):
result += ((-1) ** (k+1))/2*k-1
print result
print sequence_b(10)
This is the output which im getting
-1
-4
Denis McMahon writes:
> You have been told several times by several people how to do this
> properly. You insist on using your bodged up solution instead. OK, we'll
> all try and help you bodge up a solution[…]
Why? No-one here is obligated to help with implementing a solution we
agree is bad.
Στις 6/11/2013 12:54 πμ, ο/η John Gordon έγραψε:
The code i provided only worked once before it failed and managed to
store this:
counterID,host,refs,city,userOS,browser,visits,hits,download
-
1, 176-92-96-218.adsl.cyta.gr, Euro
On Wed, 06 Nov 2013 00:35:56 +0200, Nick the Gr33k wrote:
> Now i realizes i just cannot store lists into it's columns because it
> does not support a collection datatype.
All databases support storing of collections, but *NOT THE WAY YOU WANT
TO DO IT*
You refuse to do it the proper way, so yo
"Steven D'Aprano" wrote:
If myVar is a Unicode string, you don't need to care about the encoding
(UTF-8 or otherwise) until you're ready to write it to a file. Then I
strongly recommend you always use UTF-8, unless you have to interoperate
with some old, legacy system:
assert isinstance(myV
On 05/11/2013 22:31, Cameron Simpson wrote:
On 05Nov2013 20:09, Nikos wrote:
O even better an rdbms than allows complex data such as tuples,
lists, dicts to be saved into the db as they are so i dont have to
cobvet back and forth each time.
If you're just using the db for storage or adhoc and
There is also the shelve module.
It uses pickle to marshal a Python object, then stores it in a file
under a key.
Sample code from the module documentation:
import shelve
d = shelve.open(filename) # open -- file may get suffix added by
low-level library
d[key] = data # store data at key
On 05Nov2013 20:09, Nikos wrote:
> O even better an rdbms than allows complex data such as tuples,
> lists, dicts to be saved into the db as they are so i dont have to
> cobvet back and forth each time.
If you're just using the db for storage or adhoc and arbitrary
python objects (and not queryin
In Nick the Gr33k
writes:
> The code i provided only worked once before it failed and managed to
> store this:
>
> counterID,host,refs,city,userOS,browser,visits,hits,download
> -
> 1, 176-92-96-218.adsl.cyta.gr, Europe/Athens,
On 05/11/2013 22:28, Nick the Gr33k wrote:
Στις 6/11/2013 12:06 πμ, ο/η John Gordon έγραψε:
In Nick the Gr33k
writes:
# fetch those columns that act as lists but are stored as
strings
cur.execute('''SELECT refs, visits, downloads FROM visitors
WHERE
counterID = %s and host =
Στις 6/11/2013 12:15 πμ, ο/η Piet van Oostrum έγραψε:
Nick the Gr33k writes:
IAM STRUGGLING WITH IT 2 DAYS NOW AND I CANNOT GET IT TO WORK.
ALL I WANT IT TO DO IS JUST
1. RETRIEVE 3 COLUMNS THAT CONSIST OF 3 LONG STRINGS
2. CONVERT LONG STRINGS TO LISTS
3. ADD SOME CURRENT VALUES TO THOSE L
Στις 6/11/2013 12:06 πμ, ο/η John Gordon έγραψε:
In Nick the Gr33k
writes:
# fetch those columns that act as lists but are stored as
strings
cur.execute('''SELECT refs, visits, downloads FROM visitors
WHERE
counterID = %s and host = %s''', (cID, host) )
Nick the Gr33k writes:
>
> IAM STRUGGLING WITH IT 2 DAYS NOW AND I CANNOT GET IT TO WORK.
>
> ALL I WANT IT TO DO IS JUST
>
> 1. RETRIEVE 3 COLUMNS THAT CONSIST OF 3 LONG STRINGS
> 2. CONVERT LONG STRINGS TO LISTS
> 3. ADD SOME CURRENT VALUES TO THOSE LISTS
> 4. CONVERT FROM LISTS TO LONG STRINGS
In Nick the Gr33k
writes:
> # fetch those columns that act as lists but are stored as
> strings
> cur.execute('''SELECT refs, visits, downloads FROM visitors
> WHERE
> counterID = %s and host = %s''', (cID, host) )
> data = cur.fetchone()
>
On Wed, Nov 6, 2013 at 8:17 AM, Mark Lawrence wrote:
> I've taken a different approach. I've put the contract out to tender and
> hereby give you the winners
> http://www.mudefordwoodcommunitycentre.co.uk/playgroup-and-tiny-tots/
Sounds good! But I don't see a list of their technologies - do they
On 05/11/2013 21:17, Mark Lawrence wrote:
On 05/11/2013 20:19, John Gordon wrote:
In Nick the Gr33k
writes:
IAM STRUGGLING WITH IT 2 DAYS NOW AND I CANNOT GET IT TO WORK.
ALL I WANT IT TO DO IS JUST
1. RETRIEVE 3 COLUMNS THAT CONSIST OF 3 LONG STRINGS
2. CONVERT LONG STRINGS TO LISTS
3
Στις 5/11/2013 10:19 μμ, ο/η John Gordon έγραψε:
In Nick the Gr33k
writes:
IAM STRUGGLING WITH IT 2 DAYS NOW AND I CANNOT GET IT TO WORK.
ALL I WANT IT TO DO IS JUST
1. RETRIEVE 3 COLUMNS THAT CONSIST OF 3 LONG STRINGS
2. CONVERT LONG STRINGS TO LISTS
3. ADD SOME CURRENT VALUES TO THOS
On 05/11/2013 20:19, John Gordon wrote:
In Nick the Gr33k
writes:
IAM STRUGGLING WITH IT 2 DAYS NOW AND I CANNOT GET IT TO WORK.
ALL I WANT IT TO DO IS JUST
1. RETRIEVE 3 COLUMNS THAT CONSIST OF 3 LONG STRINGS
2. CONVERT LONG STRINGS TO LISTS
3. ADD SOME CURRENT VALUES TO THOSE LISTS
4
In Nick the Gr33k
writes:
> IAM STRUGGLING WITH IT 2 DAYS NOW AND I CANNOT GET IT TO WORK.
> ALL I WANT IT TO DO IS JUST
> 1. RETRIEVE 3 COLUMNS THAT CONSIST OF 3 LONG STRINGS
> 2. CONVERT LONG STRINGS TO LISTS
> 3. ADD SOME CURRENT VALUES TO THOSE LISTS
> 4. CONVERT FROM LISTS TO LONG STRING
On Tue, 05 Nov 2013 20:09:42 +0200, Nick the Gr33k wrote:
> Denis, i have already provided my code trying to do what i need and i
> need some commendation on how to make it work.
Nick, you're obviously trying to code way above your abilities.
If you want me to write your code, you will have to p
On Tue, Nov 5, 2013 at 1:11 PM, Tobiah wrote:
> All this problem arises because MySQL's hasn't got a datatype able to store
> an array of elements, a list.
>
> Um, yes it does. It's called a table.
> --
> https://mail.python.org/mailman/listinfo/python-list
Perhaps we are splitting hairs, but a
All this problem arises because MySQL's hasn't got a datatype able to store an
array of elements, a list.
Um, yes it does. It's called a table.
--
https://mail.python.org/mailman/listinfo/python-list
Στις 5/11/2013 8:02 μμ, ο/η Denis McMahon έγραψε:
On Tue, 05 Nov 2013 19:06:25 +0200, Nick the Gr33k wrote:
IAM STRUGGLING WITH IT 2 DAYS NOW AND I CANNOT GET IT TO WORK.
Try starting with something simple. The following is a step by step guide
to working out how you need to do this. Follow a
On Tue, 05 Nov 2013 19:06:25 +0200, Nick the Gr33k wrote:
> IAM STRUGGLING WITH IT 2 DAYS NOW AND I CANNOT GET IT TO WORK.
Try starting with something simple. The following is a step by step guide
to working out how you need to do this. Follow all the steps. Do not skip
any steps. Each stage bu
Στις 5/11/2013 7:41 μμ, ο/η Steven D'Aprano έγραψε:
On Tue, 05 Nov 2013 19:06:25 +0200, Nick the Gr33k wrote:
ALL I WANT IT TO DO IS JUST
1. RETRIEVE 3 COLUMNS THAT CONSIST OF 3 LONG STRINGS 2. CONVERT LONG
STRINGS TO LISTS
3. ADD SOME CURRENT VALUES TO THOSE LISTS 4. CONVERT FROM LISTS TO LON
Op 05-11-13 18:41, Steven D'Aprano schreef:
> On Tue, 05 Nov 2013 19:06:25 +0200, Nick the Gr33k wrote:
>
>> ALL I WANT IT TO DO IS JUST
>>
>> 1. RETRIEVE 3 COLUMNS THAT CONSIST OF 3 LONG STRINGS 2. CONVERT LONG
>> STRINGS TO LISTS
>> 3. ADD SOME CURRENT VALUES TO THOSE LISTS 4. CONVERT FROM LISTS
On Tue, 05 Nov 2013 11:34:53 +0200, Nick the Gr33k wrote:
>>> data = cur.fetchall
>>> for row in data:
> I see, but because of the traceback not being to express it more easily
> i was under the impression that data wasn't what i expected it to be.
data wasn't what you expected it to be.
The pr
On Tue, 05 Nov 2013 19:06:25 +0200, Nick the Gr33k wrote:
> ALL I WANT IT TO DO IS JUST
>
> 1. RETRIEVE 3 COLUMNS THAT CONSIST OF 3 LONG STRINGS 2. CONVERT LONG
> STRINGS TO LISTS
> 3. ADD SOME CURRENT VALUES TO THOSE LISTS 4. CONVERT FROM LISTS TO LONG
> STRINGS SO I CAN STORE SUCCESSFULLY LIST
EVERYHTIGN I TRIED FAILED.
Maybe try some of the advice you have been given instead?
--
https://mail.python.org/mailman/listinfo/python-list
> =
>
> IAM STRUGGLING WITH IT 2 DAYS NOW AND I CANNOT GET IT TO WORK.
>
> ALL I WANT IT TO DO IS JUST
>
> 1. RETRIEVE 3 COLUMNS THAT CONSIST OF 3 LONG STRINGS
> 2. CONVERT LONG STRINGS TO LISTS
> 3. ADD SOME CURRENT VALUES TO THOSE LISTS
> 4. CONVERT
==
# fetch those columns that act as lists but are stored as
strings
cur.execute('''SELECT refs, visits, downloads FROM visitors WHERE
counterID = %s and host = %s''', (cID, host) )
data = cur.fetchone()
ref
Στις 5/11/2013 1:16 μμ, ο/η Dave Angel έγραψε:
On Tue, 05 Nov 2013 12:33:49 +0200, Nick the Gr33k
wrote:
Στις 5/11/2013 12:20 μμ, ο/η Antoon Pardon έγραψε:
> Did you read the documentation of fetchone?
fetchone is like fetchall except from the fact that the former
returned
a row of data
On Tue, 05 Nov 2013 16:32:57 +0330, Mohsen Pahlevanzadeh wrote:
> Dear all,
>
> Suppose i have a variable such as : myVar = 'x'
>
> May be it initialized with myVar = u'x' or myVar = 'x'
Can't you just look at the code and tell which it is?
> So i need determine content of myVar that it's utf
Στις 5/11/2013 5:45 μμ, ο/η Tim Chase έγραψε:
On 2013-11-05 17:39, Nick the Gr33k wrote:
data = infile.readlines
You're assigning it to the bound function rather than calling the
function. Use the "call" operator:
data = infile.readlines()
-tkc
--
infile=open("myfile.txt")
data = i
As I read this thread, the original question was how to stuff
multiple values in a single sql column. Several people pointed out
that the proper way to handle multiple values related to the original
table is to use a second table or perhaps a many to many relationship
with and intermediate join t
On 2013-11-05 17:39, Nick the Gr33k wrote:
> >>> data = infile.readlines
You're assigning it to the bound function rather than calling the
function. Use the "call" operator:
data = infile.readlines()
-tkc
--
https://mail.python.org/mailman/listinfo/python-list
Στις 5/11/2013 3:15 μμ, ο/η Dave Angel έγραψε:
On Tue, 05 Nov 2013 14:25:41 +0200, Nick the Gr33k
wrote:
i tried inserting a type function to notify me of the datatype of
'data'
but that didnt help too.
What did that print show ? In what way didn't it help?
It said the type was Charles
It
On 2013-11-05, Dave Angel wrote:
> On Tue, 05 Nov 2013 16:32:57 +0330, Mohsen Pahlevanzadeh
> wrote:
>> Suppose i have a variable such as : myVar = 'x'
>
>> May be it initialized with myVar = u'x' or myVar = 'x'
>
>> So i need determine content of myVar that it's utf-8 or not, how
> can i
>> do
On Tue, 05 Nov 2013 16:32:57 +0330, Mohsen Pahlevanzadeh
wrote:
Suppose i have a variable such as : myVar = 'x'
May be it initialized with myVar = u'x' or myVar = 'x'
So i need determine content of myVar that it's utf-8 or not, how
can i
do it?
Use the type() function and compare to un
Dear all,
Suppose i have a variable such as : myVar = 'x'
May be it initialized with myVar = u'x' or myVar = 'x'
So i need determine content of myVar that it's utf-8 or not, how can i
do it?
--mohsen
--
https://mail.python.org/mailman/listinfo/python-list
On Tue, 05 Nov 2013 14:25:41 +0200, Nick the Gr33k
wrote:
i tried inserting a type function to notify me of the datatype of
'data'
but that didnt help too.
What did that print show ? In what way didn't it help?
It said the type was Charles
It didn'tprint anything
It gave some other error
It
Op 05-11-13 13:25, Nick the Gr33k schreef:
>
> # fetch those columns that act as lists but are stored as strings
> cur.execute('''SELECT refs, visits, downloads FROM visitors WHERE
> counterID = %s and host = %s''', (cID, host) )
> data = cur.fetchone()
>
> print( type(data) )
> sys.exit(0
Στις 5/11/2013 1:49 μμ, ο/η Steven D'Aprano έγραψε:
On Tue, 05 Nov 2013 12:33:49 +0200, Nick the Gr33k wrote:
Στις 5/11/2013 12:20 μμ, ο/η Antoon Pardon έγραψε:
Did you read the documentation of fetchone?
fetchone is like fetchall except from the fact that the former returned
a row of dat
On Tue, 05 Nov 2013 12:33:49 +0200, Nick the Gr33k wrote:
> Στις 5/11/2013 12:20 μμ, ο/η Antoon Pardon έγραψε:
>
>> Did you read the documentation of fetchone?
>
>
>
> fetchone is like fetchall except from the fact that the former returned
> a row of data while the latter returned a list of ro
On Tue, 05 Nov 2013 12:33:49 +0200, Nick the Gr33k
wrote:
Στις 5/11/2013 12:20 μμ, ο/η Antoon Pardon έγραψε:
> Did you read the documentation of fetchone?
fetchone is like fetchall except from the fact that the former
returned
a row of data while the latter returned a list of rows of dat
On Tue, 05 Nov 2013 11:34:53 +0200, Nick the Gr33k
wrote:
I see, but because of the traceback not being to express it more
easily
i was under the impression that data wasn't what i expected it to
be.
Exactly. So why didn't you act on that impression?
Your error message told you that data wa
Op 05-11-13 11:33, Nick the Gr33k schreef:
> Στις 5/11/2013 12:20 μμ, ο/η Antoon Pardon έγραψε:
>
>> Did you read the documentation of fetchone?
>
>
>
> fetchone is like fetchall except from the fact that the former returned
> a row of data while the latter returned a list of rows of data.
Fro
Στις 5/11/2013 12:20 μμ, ο/η Antoon Pardon έγραψε:
Did you read the documentation of fetchone?
fetchone is like fetchall except from the fact that the former returned
a row of data while the latter returned a list of rows of data.
I dont know why it copmains about:
TypeError: 'NoneType' o
On Tue, Nov 5, 2013 at 8:10 PM, M.F. wrote:
> That is what the stack trace and Christ tried to inform you.
Let's go with "and Chris tried"... no need to promote me to deity status :)
ChrisA
--
https://mail.python.org/mailman/listinfo/python-list
Op 05-11-13 10:56, Nick the Gr33k schreef:
> Στις 5/11/2013 11:34 πμ, ο/η Nick the Gr33k έγραψε:
>> Στις 5/11/2013 11:10 πμ, ο/η M.F. έγραψε:
>>> On 11/05/2013 04:54 PM, Nick the Gr33k wrote:
===
data = cur.fetchall
>>> data = cur.fetchall()
>>> That is what the stac
Op 05-11-13 10:10, M.F. schreef:
> On 11/05/2013 04:54 PM, Nick the Gr33k wrote:
>>
>>
>> ===
>> data = cur.fetchall
> data = cur.fetchall()
> That is what the stack trace and Christ tried to inform you.
And now you have depraved Nikos of the opportunity to really learn
something. I'm
Στις 5/11/2013 11:34 πμ, ο/η Nick the Gr33k έγραψε:
Στις 5/11/2013 11:10 πμ, ο/η M.F. έγραψε:
On 11/05/2013 04:54 PM, Nick the Gr33k wrote:
===
data = cur.fetchall
data = cur.fetchall()
That is what the stack trace and Christ tried to inform you.
for row in data:
===
Στις 5/11/2013 11:10 πμ, ο/η M.F. έγραψε:
On 11/05/2013 04:54 PM, Nick the Gr33k wrote:
===
data = cur.fetchall
data = cur.fetchall()
That is what the stack trace and Christ tried to inform you.
for row in data:
===
The only thing i can understand by looking the abov
Use this http://hg.python.org/cpython/file/92022b45e60b/setup.py#l36
Add the list of modules you want to disable and redo make
2013/11/5 Travis Griggs
>
> On Nov 4, 2013, at 9:22 AM, Travis Griggs wrote:
>
> > I'm playing with a BeagleBone Black running the angstrom distro. Of
> course, stock
On 11/05/2013 04:54 PM, Nick the Gr33k wrote:
===
data = cur.fetchall
data = cur.fetchall()
That is what the stack trace and Christ tried to inform you.
for row in data:
===
The only thing i can understand by looking the above 2 lines is this:
'for' fails to iterate
Am 05.11.2013 01:23, schrieb Victor Hooi:
> Hi,
>
> We have a machine running CentOS 6.4, and we're attempting to compile Python
> 3.3.2 on it:
>
> # cat /etc/redhat-release
> CentOS release 6.4 (Final)
>
> We've compiled openssl 1.0.1e 11 by hand on this box, and installed it into
Ulrich Goebel wrote:
> Hallo,
>
> again: a python beginner problem... but I spent ours to solve it without
> success.
>
> I have an object (a variable) name, which gets its value from a
> PostgreSQL database via a SELECT statement, an it sometimes has german
> special characters as ß, ä, ö...
>
Στις 5/11/2013 10:21 πμ, ο/η Chris Angelico έγραψε:
On Tue, Nov 5, 2013 at 7:07 PM, Nick the Gr33k wrote:
How is ti possible for data to be none iterable?
Do you know how to call a method in Python? If not, go back to the
beginning of the tutorial and start reading. If so, look through your
c
Στις 5/11/2013 10:21 πμ, ο/η Chris Angelico έγραψε:
On Tue, Nov 5, 2013 at 7:07 PM, Nick the Gr33k wrote:
How is ti possible for data to be none iterable?
Do you know how to call a method in Python? If not, go back to the
beginning of the tutorial and start reading. If so, look through your
c
Op 05-11-13 09:21, Chris Angelico schreef:
> On Tue, Nov 5, 2013 at 7:07 PM, Nick the Gr33k wrote:
>> How is ti possible for data to be none iterable?
>
> Do you know how to call a method in Python? If not, go back to the
> beginning of the tutorial and start reading. If so, look through your
> c
On Tue, Nov 5, 2013 at 7:07 PM, Nick the Gr33k wrote:
> How is ti possible for data to be none iterable?
Do you know how to call a method in Python? If not, go back to the
beginning of the tutorial and start reading. If so, look through your
code and see where you have a 'method' object that you
Στις 5/11/2013 8:54 πμ, ο/η Nick the Gr33k έγραψε:
Στις 5/11/2013 12:46 πμ, ο/η Denis McMahon έγραψε:
On Mon, 04 Nov 2013 19:03:58 +0200, Nick the Gr33k wrote:
There is no built in support in the python / mysql system for puttinga
list straight into a database, because mysql does not have"col
73 matches
Mail list logo
