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

Groups > comp.lang.python > #42094

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

Path csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!newsfeed101.telia.com!starscream.dk.telia.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path <rosuav@gmail.com>
X-Original-To python-list@python.org
Delivered-To python-list@mail.python.org
X-Spam-Status OK 0.023
X-Spam-Evidence '*H*': 0.95; '*S*': 0.00; 'charset:iso-8859-7': 0.04; 'yet.': 0.04; 'column': 0.07; 'says.': 0.09; '"%s"': 0.16; 'attribute.': 0.16; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'hits': 0.16; 'subject:run': 0.16; 'top-level': 0.16; 'wrote:': 0.18; 'module': 0.19; 'thu,': 0.19; 'print': 0.22; 'error': 0.23; "haven't": 0.24; 'header:In-Reply-To:1': 0.27; 'chris': 0.29; 'message-id:@mail.gmail.com': 0.30; 'asked': 0.31; 'code': 0.31; 'didnt': 0.31; 'supposed': 0.32; 'says': 0.33; 'received:209.85': 0.35; 'late': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'executing': 0.36; 'received:209': 0.37; 'to:addr:python-list': 0.38; 'pm,': 0.38; 'skip:_ 30': 0.39; 'to:addr:python.org': 0.39; 'tell': 0.60; 'no.': 0.61; 'more': 0.64; 'here': 0.66; 'mar': 0.68; 'yes': 0.68; 'webpage': 0.68; 'greece': 0.84; '\xcc\xe1\xf1\xf4\xdf\xef\xf5': 0.84; '2013': 0.98
DKIM-Signature v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type:content-transfer-encoding; bh=vkBukpby9RF3rzU2hxdTs8E8bs2b0zcNaagv2U5QO00=; b=H5H7Byf0tiA11g8zffMRxDz9sA53pc2faVuOwEsQc8zjI5ZHi6ctNmXyfdyWRrOOZz QMY4Fl4uyqGH7nhui2PMGwNz5xWtbSKlnoa8o/dLpZHWsyerKVsRebB2J5PC7Q12OBmq pmwUOvmZcVJJov9Q6wV2bWawtvAwEWnoJoJYXxI/CMQKQh2Q0fi+By/b75S1y6lWI0zN UDXkKRb6DiO75NQHDCflYlaEsiBnduDSLVNCM0UPLQtkvcvXtgrThHb6/nL6JxkyhKo/ c8+q+uIbd7RsBKY9RXkRF0hiOKOpNCMHYsz8Gtm0b/0rCEALdA38Byc8vVrzYqwgPAxN dlmQ==
MIME-Version 1.0
X-Received by 10.52.111.130 with SMTP id ii2mr11026130vdb.111.1364445314765; Wed, 27 Mar 2013 21:35:14 -0700 (PDT)
In-Reply-To <aef90a2f-3e2e-4f78-901c-58f3ad035ec1@googlegroups.com>
References <c0c16d2d-b4b2-4d7a-8f1e-606ee2030ad9@googlegroups.com> <mailman.3849.1364443225.2939.python-list@python.org> <2ac959c6-d169-452f-b622-83fe25fbd8da@googlegroups.com> <mailman.3850.1364443717.2939.python-list@python.org> <19fcf06e-8923-410c-9acd-abd4534c77bf@googlegroups.com> <mailman.3854.1364444811.2939.python-list@python.org> <aef90a2f-3e2e-4f78-901c-58f3ad035ec1@googlegroups.com>
Date Thu, 28 Mar 2013 15:35:14 +1100
Subject Re: Cannot run a single MySQLdb execute....
From Chris Angelico <rosuav@gmail.com>
To python-list@python.org
Content-Type text/plain; charset=ISO-8859-7
Content-Transfer-Encoding quoted-printable
X-BeenThere python-list@python.org
X-Mailman-Version 2.1.15
Precedence list
List-Id General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe <http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive <http://mail.python.org/pipermail/python-list/>
List-Post <mailto:python-list@python.org>
List-Help <mailto:python-list-request@python.org?subject=help>
List-Subscribe <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups comp.lang.python
Message-ID <mailman.3856.1364445317.2939.python-list@python.org> (permalink)
Lines 59
NNTP-Posting-Host 2001:888:2000:d::a6
X-Trace 1364445317 news.xs4all.nl 6876 [2001:888:2000:d::a6]:53066
X-Complaints-To abuse@xs4all.nl
Xref csiph.com comp.lang.python:42094

Show key headers only | View raw

On Thu, Mar 28, 2013 at 3:30 PM, Νίκος Γκρ33κ <nikos.gr33k@gmail.com> wrote:
> Τη Πέμπτη, 28 Μαρτίου 2013 6:26:48 π.μ. UTC+2, ο χρήστης Chris Angelico έγραψε:
>> On Thu, Mar 28, 2013 at 3:18 PM, Νίκος Γκρ33κ <nikos.gr33k@gmail.com> 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 hits FROM counters WHERE url = %s''' % page
>>
>> > print( sql )
>>
>> > cur.execute( sql )
>>
>> >
>>
>> > Now the error says:
>>
>> >
>>
>> > _mysql_exceptions.OperationalError: (1054, "Unknown column 'index.html' in 'where clause'") as you cna see at my webpage
>>
>>
>>
>> http://www.facepalm.de/
>>
>>
>>
>> Do you understand SQL injection attacks and the concept of
>>
>> parameterized queries?
>>
>>
>>
>> ChrisA
>
> Yes i know i'am not supposed to use "%s" and i dotn want to but you asked me to print the sql statemnt before executing it.
>
> please its 6:30am here in greece and  didnt had any sleep yet.
> please tell me whats wrong....

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.

ChrisA

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

Thread

Cannot run  a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 20:50 -0700
  Re: Cannot run a single MySQLdb execute.... Chris Angelico <rosuav@gmail.com> - 2013-03-28 15:00 +1100
    Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:03 -0700
      Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:08 -0700
        Re: Cannot run a single MySQLdb execute.... Chris Angelico <rosuav@gmail.com> - 2013-03-28 15:14 +1100
      Re: Cannot run a single MySQLdb execute.... Chris Angelico <rosuav@gmail.com> - 2013-03-28 15:08 +1100
        Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:18 -0700
          Re: Cannot run a single MySQLdb execute.... Chris Angelico <rosuav@gmail.com> - 2013-03-28 15:26 +1100
            Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:30 -0700
              Re: Cannot run a single MySQLdb execute.... Chris Angelico <rosuav@gmail.com> - 2013-03-28 15:35 +1100
                Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:39 -0700
                Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:39 -0700
            Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:30 -0700
        Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:18 -0700
      Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:08 -0700
        Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-28 02:44 -0700
        Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-28 02:44 -0700
      Re: Cannot run a single MySQLdb execute.... David M Chess <chess@us.ibm.com> - 2013-03-28 10:51 -0400
        Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-28 12:35 -0700
        Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-28 12:35 -0700
    Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:03 -0700
  Re: Cannot run  a single MySQLdb execute.... Alan Meyer <ameyer2@yahoo.com> - 2013-03-28 16:54 -0400
    Re: Cannot run  a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-29 00:40 -0700
      Re: Cannot run  a single MySQLdb execute.... Alan Meyer <ameyer2@yahoo.com> - 2013-03-29 13:32 -0400
        Re: Cannot run  a single MySQLdb execute.... Alan Meyer <ameyer2@yahoo.com> - 2013-03-29 13:39 -0400
          Re: Cannot run  a single MySQLdb execute.... nagia.retsina@gmail.com - 2013-03-29 12:24 -0700

csiph-web