Re: Cannot run a single MySQLdb execute....

2013-03-29 Thread nagia . retsina
Τη Παρασκευή, 29 Μαρτίου 2013 7:39:20 μ.μ. UTC+2, ο χρήστης Alan Meyer έγραψε: > On 03/29/2013 01:32 PM, Alan Meyer wrote: > > > > > However, MySQLdb is a well established module and what you're asking it > > > to do is very simple and very standard. > > > > Oh, sorry, I see that you already

Re: Cannot run a single MySQLdb execute....

2013-03-29 Thread Alan Meyer
On 03/29/2013 01:32 PM, Alan Meyer wrote: However, MySQLdb is a well established module and what you're asking it to do is very simple and very standard. Oh, sorry, I see that you already said that mysqldb won't work with python 3. My comments in the last message are irrelevant. Sorry agai

Re: Cannot run a single MySQLdb execute....

2013-03-29 Thread Alan Meyer
On 03/29/2013 03:40 AM, Νίκος Γκρ33κ wrote: ... So, just to make sure that MySQLdb isnt causeing the probkem can someone, perhaps you that is familiar with linxu conenct to my jailed shell account and install manually the 'pymysql' module because i dont know how to do it and i cannot afford to pa

Re: Cannot run a single MySQLdb execute....

2013-03-29 Thread Νίκος Γκρ33κ
Τη Πέμπτη, 28 Μαρτίου 2013 10:54:55 μ.μ. UTC+2, ο χρήστης Alan Meyer έγραψε: > On 3/27/2013 11:50 PM, Νίκος Γκρ33κ wrote: > > > I'am about to go nuts with python 3.2.3 > > > > > > Do you see somehtign wrong with the following statement? > > > > > > cur.execute( '''SELECT hits FROM counters WHE

Re: Cannot run a single MySQLdb execute....

2013-03-28 Thread Alan Meyer
On 3/27/2013 11:50 PM, Νίκος Γκρ33κ wrote: I'am about to go nuts with python 3.2.3 Do you see somehtign wrong with the following statement? cur.execute( '''SELECT hits FROM counters WHERE url = ?''', (page,) ) data = cur.fetchone() because as you can see by visiting my webpage at http://superh

Re: Cannot run a single MySQLdb execute....

2013-03-28 Thread Νίκος Γκρ33κ
Τη Πέμπτη, 28 Μαρτίου 2013 4:51:16 μ.μ. UTC+2, ο χρήστης David M Chess έγραψε: > Νίκος Γκρ33κ > : > > > > >> What paramstyle are you using? > > > > > >Yes it is Chris, but i'am not sure what exactly are you asking me. > > >Please if you cna pout it even simper for me, thank you. > > > > F

Re: Cannot run a single MySQLdb execute....

2013-03-28 Thread David M Chess
Νίκος Γκρ33κ : >> What paramstyle are you using? > >Yes it is Chris, but i'am not sure what exactly are you asking me. >Please if you cna pout it even simper for me, thank you. For instance: >>> import MySQLdb >>> MySQLdb.paramstyle 'format' FWIW and HTH, DC -- http://mail.python.org/mailman

Re: Cannot run a single MySQLdb execute....

2013-03-28 Thread Νίκος Γκρ33κ
Can someone else esxcept Chris help me please? I'm strugling with this and cannot see whats wrong. -- http://mail.python.org/mailman/listinfo/python-list

Re: Cannot run a single MySQLdb execute....

2013-03-27 Thread Νίκος Γκρ33κ
Τη Πέμπτη, 28 Μαρτίου 2013 6:35:14 π.μ. UTC+2, ο χρήστης Chris Angelico έγραψε: > No. I said to print out the paramstyle attribute. If it's that late > > and you haven't slept, get some sleep, then reread this thread. You > > may be able to respond more intelligently. What is a paramstyle attri

Re: Cannot run a single MySQLdb execute....

2013-03-27 Thread Chris Angelico
On Thu, Mar 28, 2013 at 3:30 PM, Νίκος Γκρ33κ wrote: > Τη Πέμπτη, 28 Μαρτίου 2013 6:26:48 π.μ. UTC+2, ο χρήστης Chris Angelico > έγραψε: >> On Thu, Mar 28, 2013 at 3:18 PM, Νίκος Γκρ33κ wrote: >> >> > Τη Πέμπτη, 28 Μαρτίου 2013 6:08:28 π.μ. UTC+2, ο χρήστης Chris Angelico >> > έγραψε: >> >> > >

Re: Cannot run a single MySQLdb execute....

2013-03-27 Thread Νίκος Γκρ33κ
Τη Πέμπτη, 28 Μαρτίου 2013 6:26:48 π.μ. UTC+2, ο χρήστης Chris Angelico έγραψε: > On Thu, Mar 28, 2013 at 3:18 PM, Νίκος Γκρ33κ wrote: > > > Τη Πέμπτη, 28 Μαρτίου 2013 6:08:28 π.μ. UTC+2, ο χρήστης Chris Angelico > > έγραψε: > > > > > >> As it says in that document, paramstyle is a top-level m

Re: Cannot run a single MySQLdb execute....

2013-03-27 Thread Chris Angelico
On Thu, Mar 28, 2013 at 3:18 PM, Νίκος Γκρ33κ wrote: > Τη Πέμπτη, 28 Μαρτίου 2013 6:08:28 π.μ. UTC+2, ο χρήστης Chris Angelico > έγραψε: > >> As it says in that document, paramstyle is a top-level module >> attribute. Try printing it out. See what it says. Then match your code > > sql = '''SELECT

Re: Cannot run a single MySQLdb execute....

2013-03-27 Thread Νίκος Γκρ33κ
Τη Πέμπτη, 28 Μαρτίου 2013 6:08:28 π.μ. UTC+2, ο χρήστης Chris Angelico έγραψε: > As it says in that document, paramstyle is a top-level module > attribute. Try printing it out. See what it says. Then match your code sql = '''SELECT hits FROM counters WHERE url = %s''' % page print( sql ) cur.ex

Re: Cannot run a single MySQLdb execute....

2013-03-27 Thread Chris Angelico
On Thu, Mar 28, 2013 at 3:08 PM, Νίκος Γκρ33κ wrote: > If you mean if iam using '?' or this '%s' the latter used to work flawlessly > with python 2.6 but it does not in pythin 3.2.3 Print out the value of that attribute. ChrisA -- http://mail.python.org/mailman/listinfo/python-list

Re: Cannot run a single MySQLdb execute....

2013-03-27 Thread Νίκος Γκρ33κ
If you mean if iam using '?' or this '%s' the latter used to work flawlessly with python 2.6 but it does not in pythin 3.2.3 both this command fail in python 3.x cur.execute( '''SELECT hits FROM counters WHERE url = ?''', (page,) ) cur.execute( '''SELECT hits FROM counters WHERE url = %s''', (

Re: Cannot run a single MySQLdb execute....

2013-03-27 Thread Chris Angelico
On Thu, Mar 28, 2013 at 3:03 PM, Νίκος Γκρ33κ wrote: > Τη Πέμπτη, 28 Μαρτίου 2013 6:00:17 π.μ. UTC+2, ο χρήστης Chris Angelico > έγραψε: > >> What paramstyle are you using? > > Yes it is Chris, but i'am not sure what exactly are you asking me. > Please if you cna pout it even simper for me, thank

Re: Cannot run a single MySQLdb execute....

2013-03-27 Thread Νίκος Γκρ33κ
Τη Πέμπτη, 28 Μαρτίου 2013 6:00:17 π.μ. UTC+2, ο χρήστης Chris Angelico έγραψε: > What paramstyle are you using? Yes it is Chris, but i'am not sure what exactly are you asking me. Please if you cna pout it even simper for me, thank you. -- http://mail.python.org/mailman/listinfo/python-list

Re: Cannot run a single MySQLdb execute....

2013-03-27 Thread Chris Angelico
On Thu, Mar 28, 2013 at 2:50 PM, Νίκος Γκρ33κ wrote: > I'am about to go nuts with python 3.2.3 > > Do you see somehtign wrong with the following statement? > > cur.execute( '''SELECT hits FROM counters WHERE url = ?''', (page,) ) > data = cur.fetchone() > > because as you can see by visiting my we

Cannot run a single MySQLdb execute....

2013-03-27 Thread Νίκος Γκρ33κ
I'am about to go nuts with python 3.2.3 Do you see somehtign wrong with the following statement? cur.execute( '''SELECT hits FROM counters WHERE url = ?''', (page,) ) data = cur.fetchone() because as you can see by visiting my webpage at http://superhost.gr it produces an error and i dont have