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


Groups > comp.lang.python > #4005

Re: strange use of %s

Path csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!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.020
X-Spam-Evidence '*H*': 0.96; '*S*': 0.00; 'arguments': 0.05; 'string,': 0.05; 'abstraction': 0.07; 'parsing': 0.09; 'statement.': 0.09; 'am,': 0.14; 'wrote:': 0.14; 'defined': 0.15; 'signs': 0.16; 'tue,': 0.20; 'header:In-Reply-To:1': 0.22; 'that?': 0.23; 'chris': 0.27; 'message-id:@mail.gmail.com': 0.28; "doesn't": 0.28; 'string': 0.29; 'query': 0.29; "can't": 0.31; 'to:addr:python-list': 0.32; 'character': 0.33; 'worry': 0.33; 'difference': 0.35; 'subject:use': 0.35; 'think': 0.36; 'received:209.85': 0.37; 'apr': 0.38; 'received:google.com': 0.38; 'but': 0.38; 'happens': 0.38; 'here,': 0.39; 'to:addr:python.org': 0.39; 'where': 0.39; 'received:209': 0.39; 'how': 0.39; 'header:Received:5': 0.40; '2011': 0.62; '26,': 0.68; 'escaping': 0.84; 'received:209.85.210.174': 0.84; 'received:mail- iy0-f174.google.com': 0.84
DKIM-Signature v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type:content-transfer-encoding; bh=yogyIeaBm/t04PF2AuF7t8n1QYLrIiaMc/FulTgGFko=; b=CbUSq8Pb1L1gvx+mb1YLqAGkvsw8KdnJxr2ocaC1HvrOv1p2x3EIWmveKzrOFpI9hd /Kfd3/S7ox2bELlM+OHizmHFylShCHRTjgx3KrEM/uiqs2MjkzeBD2SEc8TnRMHeaqvo rQ6bzR/ojIfjaOBtTUHVP4agWMQFXmYME1vnA=
DomainKey-Signature a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; b=vTz8xsdJc364AO8cgxPFU2hqEESmpvS21k5L37TTGqtZtZXpNxvkjbnc+tUTmEu3q3 9hZhsz4mYbCAq2iEcsoFBXv+Q1azspLOoLXVkHcdTGyHJ4p/EK7LV+jromLD8Qt8rNg6 vEpvTELeHAW7h2CvvD1L5OhK3Sp0cPgAcBDPY=
MIME-Version 1.0
In-Reply-To <4db5ef2d$0$10574$742ec2ed@news.sonic.net>
References <4dabf65a$0$18250$4fafbaef@reader2.news.tin.it> <mailman.505.1303116284.9059.python-list@python.org> <4db5ef2d$0$10574$742ec2ed@news.sonic.net>
Date Tue, 26 Apr 2011 08:10:26 +1000
Subject Re: strange use of %s
From Chris Angelico <rosuav@gmail.com>
To python-list@python.org
Content-Type text/plain; charset=ISO-8859-1
Content-Transfer-Encoding quoted-printable
X-BeenThere python-list@python.org
X-Mailman-Version 2.1.12
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.823.1303769429.9059.python-list@python.org> (permalink)
Lines 14
NNTP-Posting-Host 82.94.164.166
X-Trace 1303769430 news.xs4all.nl 81479 [::ffff:82.94.164.166]:39043
X-Complaints-To abuse@xs4all.nl
Xref x330-a1.tempe.blueboxinc.net comp.lang.python:4005

Show key headers only | View raw


On Tue, Apr 26, 2011 at 8:01 AM, John Nagle <nagle@animats.com> wrote:
> Don't worry about having MySQL do the CONCAT.  That happens
> once during query parsing here, because all the arguments to
> CONCAT are defined in the statement.
>

Good point. Although the abstraction is still a little leaky in that
you can't use this to search for a percent character anywhere in the
string (come to think of it, how _would_ you do that? I think you'd
have to backslash-escape it, prior to escaping it for the string, but
I'd have to check), so it doesn't make a lot of difference where the
percent signs are added.

Chris Angelico

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


Thread

strange use of %s Tracubik <affdfsdfdsfsd@b.com> - 2011-04-18 08:29 +0000
  Re: strange use of %s Tim Golden <mail@timgolden.me.uk> - 2011-04-18 09:44 +0100
    Re: strange use of %s John Nagle <nagle@animats.com> - 2011-04-25 15:01 -0700
      Re: strange use of %s Chris Angelico <rosuav@gmail.com> - 2011-04-26 08:10 +1000
  Re: strange use of %s Chris Angelico <rosuav@gmail.com> - 2011-04-18 18:50 +1000
  Re: strange use of %s Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2011-04-18 22:22 -0700
  Re: strange use of %s Chris Angelico <rosuav@gmail.com> - 2011-04-19 15:31 +1000
  Re: strange use of %s Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2011-04-19 21:01 -0700

csiph-web