On Sunday, March 26, 2017 at 7:55:09 PM UTC+5:30, Νίκος Βέργος wrote:
> Τη Κυριακή, 26 Μαρτίου 2017 - 5:19:27 μ.μ. UTC+3, ο χρήστης Ian έγραψε:
>
> > You need to change the placeholders back. The poster who told you to
> > replace them was misinformed.
>
> okey altered them back to
>
> cur.execu
Gregory Ewing writes:
> Νίκος Βέργος wrote:
>
>> Its still a mystery to em whay this fails syntactically when at the
>> same time INSERT works like that.
>
> I don't think *anyone* understands why SQL was designed with
> INSERT and UPDATE having completely different syntaxes.
> But it was, and we
Νίκος Βέργος wrote:
Its still a mystery to em whay this fails syntactically when at the same time
INSERT works like that.
I don't think *anyone* understands why SQL was designed with
INSERT and UPDATE having completely different syntaxes.
But it was, and we have to live with it.
--
Greg
--
ht
Thank you very much Johann.
i was using print(update wuery here) and i was seeing that print was able
to parser the query and that consused me as to why execute wont do the same
since with print all values was gettign substituted.
of course pymysql doesnt behave the same with print but until i fu
Νίκος,
I am glad that you solved the problem.
I am not using mysql but postgresql. When I get a problem using python to
communicate with the database, one of my first steps will be to determine
whether the error is a python (maybe psycopg-related) related error or a
database error. What I do th
Τη Δευτέρα, 27 Μαρτίου 2017 - 6:00:34 π.μ. UTC+3, ο χρήστης Chris Angelico
έγραψε:
> On Mon, Mar 27, 2017 at 1:52 PM, Νίκος Βέργος wrote:
> > Its NOT that i have not read it exactly, but for some strange reason i was
> > under the belief that the way i had syntactically typed the UPDATE query
>
On Mon, Mar 27, 2017 at 1:52 PM, Νίκος Βέργος wrote:
> Its NOT that i have not read it exactly, but for some strange reason i was
> under the belief that the way i had syntactically typed the UPDATE query was
> correctly and more consistent and similar to thr INSERT query and it was
> prefered
Τη Δευτέρα, 27 Μαρτίου 2017 - 5:43:01 π.μ. UTC+3, ο χρήστης Chris Angelico
έγραψε:
> On Mon, Mar 27, 2017 at 1:39 PM, Νίκος Βέργος wrote:
> >> MariaDB / MySQL shows part of your SQL from where they failed to parse.
> >> In your case, your MariaDB can't parse from '('
> >> LIKE clause is not probl
On Mon, Mar 27, 2017 at 1:39 PM, Νίκος Βέργος wrote:
>> MariaDB / MySQL shows part of your SQL from where they failed to parse.
>> In your case, your MariaDB can't parse from '('
>> LIKE clause is not problem for this issue?
>
> Yes indeed it is.
> I was just so sure that UPDATE was working like I
Τη Δευτέρα, 27 Μαρτίου 2017 - 2:27:31 π.μ. UTC+3, ο χρήστης INADA Naoki έγραψε:
> > i dont have to update table set column1 = this value, column2=that value and
> > so on
>
> Why do you think so? Did you really read the manual?
>
> mysql> create table test_update (a int primary key, b int, c int
On Mon, 27 Mar 2017 07:13 am, Νίκος Βέργος wrote:
> OMG!!! It actually worked!
>
> Can't believe that 3 days in a row i have tried everything concerning
> string manipulation and mysql escaping nd the error was the UPDATE
> itself
You tried everything except what we told you, over and over a
> i dont have to update table set column1 = this value, column2=that value and
> so on
Why do you think so? Did you really read the manual?
mysql> create table test_update (a int primary key, b int, c int);
Query OK, 0 rows affected (0.02 sec)
mysql> insert into test_update values (1, 2, 3);
Qu
On Sunday, March 26, 2017 at 8:33:49 PM UTC+1, Νίκος Βέργος wrote:
> Τη Κυριακή, 26 Μαρτίου 2017 - 10:23:27 μ.μ. UTC+3, ο χρήστης
> bream...@gmail.com έγραψε:
> > On Sunday, March 26, 2017 at 4:11:54 PM UTC+1, Νίκος Βέργος wrote:
> > > Τη Κυριακή, 26 Μαρτίου 2017 - 5:49:00 μ.μ. UTC+3, ο χρήστης Ia
On Sunday, March 26, 2017 at 4:11:54 PM UTC+1, Νίκος Βέργος wrote:
> Τη Κυριακή, 26 Μαρτίου 2017 - 5:49:00 μ.μ. UTC+3, ο χρήστης Ian έγραψε:
>
> > The database wrapper won't do substitution into the middle of a string
> > like that. Either concatenate the literal %'s on in the SQL statement
> > or
Τη Κυριακή, 26 Μαρτίου 2017 - 11:59:21 μ.μ. UTC+3, ο χρήστης Larry Hudson
έγραψε:
> On 03/26/2017 01:21 AM, Νίκος Βέργος wrote:
> > print('''UPDATE visitors SET (pagesID, host, ref, location, useros,
> > browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE
> > "%s"''', (pID, doma
On 03/26/2017 01:21 AM, Νίκος Βέργος wrote:
print('''UPDATE visitors SET (pagesID, host, ref, location, useros, browser, visits)
VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE "%s"''', (pID, domain, ref,
location, useros, browser, lastvisit, domain) )
prints out:
UPDATE visitors SET (pag
Τη Κυριακή, 26 Μαρτίου 2017 - 11:05:34 μ.μ. UTC+3, ο χρήστης Νίκος Βέργος
έγραψε:
> Τη Κυριακή, 26 Μαρτίου 2017 - 10:56:07 μ.μ. UTC+3, ο χρήστης Chris Angelico
> έγραψε:
> > On Mon, Mar 27, 2017 at 6:33 AM, Νίκος Βέργος wrote:
> > > Since i'm incopetent as you suggest i'am show us your level of
Τη Κυριακή, 26 Μαρτίου 2017 - 10:56:07 μ.μ. UTC+3, ο χρήστης Chris Angelico
έγραψε:
> On Mon, Mar 27, 2017 at 6:33 AM, Νίκος Βέργος wrote:
> > Since i'm incopetent as you suggest i'am show us your level of skills and
> > expertise and provide a solution, otherwise you are also what you claim of
On Mon, Mar 27, 2017 at 6:33 AM, Νίκος Βέργος wrote:
> Since i'm incopetent as you suggest i'am show us your level of skills and
> expertise and provide a solution, otherwise you are also what you claim of me.
It's not his problem. An expert does not have to provide solutions to
prove his expert
Τη Κυριακή, 26 Μαρτίου 2017 - 10:23:27 μ.μ. UTC+3, ο χρήστης bream...@gmail.com
έγραψε:
> On Sunday, March 26, 2017 at 4:11:54 PM UTC+1, Νίκος Βέργος wrote:
> > Τη Κυριακή, 26 Μαρτίου 2017 - 5:49:00 μ.μ. UTC+3, ο χρήστης Ian έγραψε:
> >
> > > The database wrapper won't do substitution into the mi
Τη Κυριακή, 26 Μαρτίου 2017 - 10:04:31 μ.μ. UTC+3, ο χρήστης Chris Angelico
έγραψε:
> On Mon, Mar 27, 2017 at 5:52 AM, Νίκος Βέργος wrote:
> > Τη Κυριακή, 26 Μαρτίου 2017 - 9:32:13 μ.μ. UTC+3, ο χρήστης Chris Angelico
> > έγραψε:
> >> On Mon, Mar 27, 2017 at 4:54 AM, Νίκος Βέργος wrote:
> >> >
On Mon, Mar 27, 2017 at 5:52 AM, Νίκος Βέργος wrote:
> Τη Κυριακή, 26 Μαρτίου 2017 - 9:32:13 μ.μ. UTC+3, ο χρήστης Chris Angelico
> έγραψε:
>> On Mon, Mar 27, 2017 at 4:54 AM, Νίκος Βέργος wrote:
>> > Τη Κυριακή, 26 Μαρτίου 2017 - 8:06:07 μ.μ. UTC+3, ο χρήστης INADA Naoki
>> > έγραψε:
>> >> Rea
Τη Κυριακή, 26 Μαρτίου 2017 - 8:58:55 μ.μ. UTC+3, ο χρήστης alister έγραψε:
> On Sun, 26 Mar 2017 07:43:51 -0700, Νίκος Βέργος wrote:
>
> > Τη Κυριακή, 26 Μαρτίου 2017 - 5:38:57 μ.μ. UTC+3, ο χρήστης alister
> > έγραψε:
> >> On Sun, 26 Mar 2017 07:24:49 -0700, Νίκος Βέργος wrote:
> >>
> >> > Τη Κ
Τη Κυριακή, 26 Μαρτίου 2017 - 9:32:13 μ.μ. UTC+3, ο χρήστης Chris Angelico
έγραψε:
> On Mon, Mar 27, 2017 at 4:54 AM, Νίκος Βέργος wrote:
> > Τη Κυριακή, 26 Μαρτίου 2017 - 8:06:07 μ.μ. UTC+3, ο χρήστης INADA Naoki
> > έγραψε:
> >> Read my mail again.
> >>
> >> > This error came from MySQL. If t
On Sunday, March 26, 2017 at 3:11:50 PM UTC+1, Ian wrote:
> On Sun, Mar 26, 2017 at 7:39 AM, MeV wrote:
> > On Sunday, March 26, 2017 at 6:34:30 AM UTC-7, Νίκος Βέργος wrote:
> >> with import cgitb; cgitb.enable()
> >>
> >> ProgrammingError(1064, "You have an error in your SQL syntax; check the
>
On Mon, Mar 27, 2017 at 4:54 AM, Νίκος Βέργος wrote:
> Τη Κυριακή, 26 Μαρτίου 2017 - 8:06:07 μ.μ. UTC+3, ο χρήστης INADA Naoki
> έγραψε:
>> Read my mail again.
>>
>> > This error came from MySQL. If there are no logs in error_log, it's
>> > your configuration issue.
>>
>> > See https://dev.mysql
On Sun, 26 Mar 2017 07:43:51 -0700, Νίκος Βέργος wrote:
> Τη Κυριακή, 26 Μαρτίου 2017 - 5:38:57 μ.μ. UTC+3, ο χρήστης alister
> έγραψε:
>> On Sun, 26 Mar 2017 07:24:49 -0700, Νίκος Βέργος wrote:
>>
>> > Τη Κυριακή, 26 Μαρτίου 2017 - 5:19:27 μ.μ. UTC+3, ο χρήστης Ian
>> > έγραψε:
>> >
>> >> You n
Τη Κυριακή, 26 Μαρτίου 2017 - 8:06:07 μ.μ. UTC+3, ο χρήστης INADA Naoki έγραψε:
> Read my mail again.
>
> > This error came from MySQL. If there are no logs in error_log, it's
> > your configuration issue.
>
> > See https://dev.mysql.com/doc/refman/5.7/en/update.html for Update
> > statement syn
I do not see why my UPDATE fails.
cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros,
browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s)''') works
i dont have to update table set column1 = this value, column2=that value
and so on
It's just when the LIKE clause jumps in th
Read my mail again.
> This error came from MySQL. If there are no logs in error_log, it's
> your configuration issue.
> See https://dev.mysql.com/doc/refman/5.7/en/update.html for Update
> statement syntax.
--
https://mail.python.org/mailman/listinfo/python-list
Any ideas on how to make progress on that?
After all its just an UPDATE with a WHERE clause?!
Do you also think is DBI related issue?
--
https://mail.python.org/mailman/listinfo/python-list
On Sun, Mar 26, 2017 at 11:48 AM, Νίκος Βέργος wrote:
> Τη Κυριακή, 26 Μαρτίου 2017 - 6:39:01 μ.μ. UTC+3, ο χρήστης Steve D'Aprano
> έγραψε:
>> On Mon, 27 Mar 2017 02:11 am, Νίκος Βέργος wrote:
>>
>> > I just tried:
>> >
>> > domain = '.'.join( host.split('.')[-2:] )
>> > domain = '%' + domain +
Currently to avoid any misinformations my code looks as follows:
domain = '.'.join( host.split('.')[-2:] )
domain_query = '%%%s' % domain
cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros,
browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE %s''',
(pID, d
On Mon, Mar 27, 2017 at 2:48 AM, Νίκος Βέργος wrote:
>> > which you can see at http://superhost.gr
>>
>> Ah, Nikos, its been a long time! I thought I recognised your style of
>> posting.
>
>
> Howdy Steve!
> Yes its me and yes its have been a long time! How are you?!
>
Irony lost.
ChrisA
--
htt
Τη Κυριακή, 26 Μαρτίου 2017 - 6:39:01 μ.μ. UTC+3, ο χρήστης Steve D'Aprano
έγραψε:
> On Mon, 27 Mar 2017 02:11 am, Νίκος Βέργος wrote:
>
> > I just tried:
> >
> > domain = '.'.join( host.split('.')[-2:] )
> > domain = '%' + domain + '%'
> >
> > cur.execute('''UPDATE visitors SET (pagesID, host,
Τη Κυριακή, 26 Μαρτίου 2017 - 6:28:12 μ.μ. UTC+3, ο χρήστης Chris Angelico
έγραψε:
> On Mon, Mar 27, 2017 at 2:11 AM, Νίκος Βέργος wrote:
> > Τη Κυριακή, 26 Μαρτίου 2017 - 5:49:00 μ.μ. UTC+3, ο χρήστης Ian έγραψε:
> >
> >> The database wrapper won't do substitution into the middle of a string
> >
On Mon, 27 Mar 2017 02:11 am, Νίκος Βέργος wrote:
> I just tried:
>
> domain = '.'.join( host.split('.')[-2:] )
> domain = '%' + domain + '%'
>
> cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros,
> browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE "%s"
On Mon, Mar 27, 2017 at 2:11 AM, Νίκος Βέργος wrote:
> Τη Κυριακή, 26 Μαρτίου 2017 - 5:49:00 μ.μ. UTC+3, ο χρήστης Ian έγραψε:
>
>> The database wrapper won't do substitution into the middle of a string
>> like that. Either concatenate the literal %'s on in the SQL statement
>> or add them to the
domain = '.'.join( host.split('.')[-2:] )
domain = '%' + domain + '%'
domain = '%%%s%%' % domain
domain = '%{}%'.format(domain)
cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros,
browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE "%s" ''',
Τη Κυριακή, 26 Μαρτίου 2017 - 5:49:00 μ.μ. UTC+3, ο χρήστης Ian έγραψε:
> The database wrapper won't do substitution into the middle of a string
> like that. Either concatenate the literal %'s on in the SQL statement
> or add them to the string before you pass it in, i.e. '%' + domain +
> '%' or '
On Sun, Mar 26, 2017 at 8:24 AM, Νίκος Βέργος wrote:
> Τη Κυριακή, 26 Μαρτίου 2017 - 5:19:27 μ.μ. UTC+3, ο χρήστης Ian έγραψε:
>
>> You need to change the placeholders back. The poster who told you to
>> replace them was misinformed.
>
> okey altered them back to
>
> cur.execute('''UPDATE visitors
I see thank you for pointing that out.
Now i'm receiving no error in error_log but when i'm running the script
it displays this:
ProgrammingError(1064, "You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right syntax
to use near '(pages
On Mon, 27 Mar 2017 12:52 am, Νίκος Βέργος wrote:
> cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros,
> browser, visits) VALUES ({}, {}, {}, {}, {}, {}, {}) WHERE host LIKE
> "{}"'''.format(pID, domain, ref, location, useros, browser, lastvisit,
> domain) )
>
> Same kind o
i have tried that 2 days ago.
Problem is that you maintained space before and after '%s' which wont work
within like
How would you type it without space as in "%%s%" ?
Στις Κυρ, 26 Μαρ 2017 στις 5:32 μ.μ., ο/η INADA Naoki <
songofaca...@gmail.com> έγραψε:
> > I MEAN HOW TO DIFFERENTIATE '%S' F
On Mon, 27 Mar 2017 01:24 am, Νίκος Βέργος wrote:
> I MEAN HOW TO DIFFERENTIATE '%S' FROM LITERAL '%' character.
Use %% for a literal percent character.
py> '%s %% %s' % ('hello', 'world')
'hello % world'
--
Steve
“Cheer up,” they said, “things could be worse.” So I cheered up, and sure
en
Τη Κυριακή, 26 Μαρτίου 2017 - 5:38:57 μ.μ. UTC+3, ο χρήστης alister έγραψε:
> On Sun, 26 Mar 2017 07:24:49 -0700, Νίκος Βέργος wrote:
>
> > Τη Κυριακή, 26 Μαρτίου 2017 - 5:19:27 μ.μ. UTC+3, ο χρήστης Ian έγραψε:
> >
> >> You need to change the placeholders back. The poster who told you to
> >> re
On Sun, 26 Mar 2017 07:24:49 -0700, Νίκος Βέργος wrote:
> Τη Κυριακή, 26 Μαρτίου 2017 - 5:19:27 μ.μ. UTC+3, ο χρήστης Ian έγραψε:
>
>> You need to change the placeholders back. The poster who told you to
>> replace them was misinformed.
>
> okey altered them back to
>
> cur.execute('''UPDATE vi
I used space only for readability. It's not required.
>>> '%%%s%%' % (42,)
'%42%'
On Sun, Mar 26, 2017 at 11:35 PM, Νίκος Βέργος wrote:
> i have tried that 2 days ago.
>
> Problem is that you maintained space before and after '%s' which wont work
> within like
>
> How would you type it without
> I MEAN HOW TO DIFFERENTIATE '%S' FROM LITERAL '%' character.
>
>>> '%% %s %%s' % (42,)
'% 42 %s'
Use %%
--
https://mail.python.org/mailman/listinfo/python-list
Τη Κυριακή, 26 Μαρτίου 2017 - 5:19:27 μ.μ. UTC+3, ο χρήστης Ian έγραψε:
> You need to change the placeholders back. The poster who told you to
> replace them was misinformed.
okey altered them back to
cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros,
browser, visits) VAL
On Sun, Mar 26, 2017 at 8:07 AM, Νίκος Βέργος wrote:
> Τη Κυριακή, 26 Μαρτίου 2017 - 5:04:27 μ.μ. UTC+3, ο χρήστης INADA Naoki This
> error came from MySQL. If there are no logs in error_log, it's
>> your configuration issue.
>>
>> See https://dev.mysql.com/doc/refman/5.7/en/update.html for Upda
On Sun, Mar 26, 2017 at 7:39 AM, MeV wrote:
> On Sunday, March 26, 2017 at 6:34:30 AM UTC-7, Νίκος Βέργος wrote:
>> with import cgitb; cgitb.enable()
>>
>> ProgrammingError(1064, "You have an error in your SQL syntax; check the
>> manual that corresponds to your MariaDB server version for the rig
Τη Κυριακή, 26 Μαρτίου 2017 - 5:04:27 μ.μ. UTC+3, ο χρήστης INADA Naoki This
error came from MySQL. If there are no logs in error_log, it's
> your configuration issue.
>
> See https://dev.mysql.com/doc/refman/5.7/en/update.html for Update
> statement syntax.
cur.execute('''UPDATE visitors SET (
"Νίκος Βέργος" wrote in message
news:8c5f0443-c61b-4059-8d6f-576152d59...@googlegroups.com...
cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros,
browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE
%s''',
(pID, domain, ref, location, useros, browser,
On Sun, Mar 26, 2017 at 10:34 PM, Νίκος Βέργος wrote:
> with import cgitb; cgitb.enable()
>
> ProgrammingError(1064, "You have an error in your SQL syntax; check the
> manual that corresponds to your MariaDB server version for the right syntax
> to use near '(pagesID, host, ref, location, useros
cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros,
browser, visits) VALUES ({}, {}, {}, {}, {}, {}, {}) WHERE host LIKE
"{}"'''.format(pID, domain, ref, location, useros, browser, lastvisit, domain) )
Same kind of output in the error-log even with this attempt.
--
https:/
Τη Κυριακή, 26 Μαρτίου 2017 - 4:39:44 μ.μ. UTC+3, ο χρήστης MeV έγραψε:
> On Sunday, March 26, 2017 at 6:34:30 AM UTC-7, Νίκος Βέργος wrote:
> > with import cgitb; cgitb.enable()
> >
> > ProgrammingError(1064, "You have an error in your SQL syntax; check the
> > manual that corresponds to your Ma
Τη Κυριακή, 26 Μαρτίου 2017 - 4:39:44 μ.μ. UTC+3, ο χρήστης MeV έγραψε:
> On Sunday, March 26, 2017 at 6:34:30 AM UTC-7, Νίκος Βέργος wrote:
> > with import cgitb; cgitb.enable()
> >
> > ProgrammingError(1064, "You have an error in your SQL syntax; check the
> > manual that corresponds to your Ma
Ths is the whole snippert i'am trying so you can see what i'm tryong to do.
[code]
# if bot is contained in hostname update all previous database
bot hostname entries with current bot hostname
for bot in bots:
if bot in host:
On Sunday, March 26, 2017 at 6:34:30 AM UTC-7, Νίκος Βέργος wrote:
> with import cgitb; cgitb.enable()
>
> ProgrammingError(1064, "You have an error in your SQL syntax; check the
> manual that corresponds to your MariaDB server version for the right syntax
> to use near '(pagesID, host, ref, loc
with import cgitb; cgitb.enable()
ProgrammingError(1064, "You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax to use
near '(pagesID, host, ref, location, useros, browser, visits) VALUES (1,
'cyta.gr', '' at line 1")
that i
Νίκος Βέργος writes:
> print('''UPDATE visitors SET (pagesID, host, ref, location, useros,
> browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE
> "%s"''', (pID, domain, ref, location, useros, browser, lastvisit,
> domain) )
>
> prints out:
>
> UPDATE visitors SET (pagesID, host,
In reply to my own question, postgres column names must begin with a letter or
an underscore. So this is what I have done:
>>> for row in cursor_from:
... if row[8]:
... stn_list_short.append("_" + row[0])
I can now use stn_list_short to create my columns
--
http://mail.python.org/m
On 4/5/2012 10:10 PM, Steve Howell wrote:
On Apr 5, 9:59 pm, rusi wrote:
On Apr 6, 6:56 am, Steve Howell wrote:
You've one-upped me with 2-to-the-N backspace escaping.
Early attempts at UNIX word processing, "nroff" and "troff",
suffered from that problem, due to a badly designed macro
On Apr 6, 10:13 am, Steve Howell wrote:
> On Apr 5, 9:59 pm,rusi wrote:
>
> > On Apr 6, 6:56 am,SteveHowell wrote:
>
> > > One of the biggest nuisances for programmers, just beneath date/time
> > > APIs in the pantheon of annoyances, is that we are constantly dealing
> > > with escaping/encoding/f
This was the original intention, i.e. 'format' preferred over '%' but
even the core developers have backtracked on this issue. If I could
remember the thread it was on I'd give you a reference, but I haven't
the faintest idea as to which mailing list it was on. I'm certain that
other subscribers w
On Mon, 16 Apr 2012 23:27:04 +, Steven D'Aprano wrote:
> On Mon, 16 Apr 2012 23:12:52 +, Steven D'Aprano wrote:
>
>> But it does. Before making assumptions about what format does and does
>> not offer, remember that the Fine Manual is your friend.
>
> Ha, it would help if I remembered to
On 16/04/2012 11:03, Kiuhnm wrote:
I like this one. Since I read somewhere that 'format' is preferred over
'%', I was focusing on 'format' and I didn't think of '%'.
Anyway, it's odd that 'format' doesn't offer something similar.
Kiuhnm
This was the original intention, i.e. 'format' preferred
On Mon, 16 Apr 2012 23:12:52 +, Steven D'Aprano wrote:
> But it does. Before making assumptions about what format does and does
> not offer, remember that the Fine Manual is your friend.
Ha, it would help if I remembered to link to the manual... sorry about
that.
http://docs.python.org/libr
On Mon, 16 Apr 2012 12:03:31 +0200, Kiuhnm wrote:
> On 4/16/2012 4:42, Steven D'Aprano wrote:
>> On Sun, 15 Apr 2012 23:07:36 +0200, Kiuhnm wrote:
>>
>>> This is the behavior I need:
>>> path = path.replace('\\', '')
>>> msg = ". {} .. '{}' .. {} .".format(a, path, b)
>>> Is there
On 4/16/2012 17:14, Jon Clements wrote:
On Monday, 16 April 2012 11:03:31 UTC+1, Kiuhnm wrote:
On 4/16/2012 4:42, Steven D'Aprano wrote:
On Sun, 15 Apr 2012 23:07:36 +0200, Kiuhnm wrote:
This is the behavior I need:
path = path.replace('\\', '')
msg = ". {} .. '{}' .. {} ."
On Monday, 16 April 2012 11:03:31 UTC+1, Kiuhnm wrote:
> On 4/16/2012 4:42, Steven D'Aprano wrote:
> > On Sun, 15 Apr 2012 23:07:36 +0200, Kiuhnm wrote:
> >
> >> This is the behavior I need:
> >> path = path.replace('\\', '')
> >> msg = ". {} .. '{}' .. {} .".format(a, path, b)
> >
16.04.12 00:07, Kiuhnm написав(ла):
path = path.replace('\\', '')
If you think that it is too complicated:
path = re.sub('', '', path)
--
http://mail.python.org/mailman/listinfo/python-list
On 4/16/2012 12:03, Kiuhnm wrote:
On 4/16/2012 4:42, Steven D'Aprano wrote:
On Sun, 15 Apr 2012 23:07:36 +0200, Kiuhnm wrote:
This is the behavior I need:
path = path.replace('\\', '')
msg = ". {} .. '{}' .. {} .".format(a, path, b)
Is there a better way?
This works for me:
a = "spam"
Kiuhnm wrote:
> On 4/16/2012 4:42, Steven D'Aprano wrote:
>> On Sun, 15 Apr 2012 23:07:36 +0200, Kiuhnm wrote:
>>
>>> This is the behavior I need:
>>> path = path.replace('\\', '')
>>> msg = ". {} .. '{}' .. {} .".format(a, path, b)
>>> Is there a better way?
>>
>>
>> This works fo
On 4/16/2012 4:42, Steven D'Aprano wrote:
On Sun, 15 Apr 2012 23:07:36 +0200, Kiuhnm wrote:
This is the behavior I need:
path = path.replace('\\', '')
msg = ". {} .. '{}' .. {} .".format(a, path, b)
Is there a better way?
This works for me:
a = "spam"
b = "ham"
path = r"C:\
On Sun, 15 Apr 2012 23:07:36 +0200, Kiuhnm wrote:
> This is the behavior I need:
> path = path.replace('\\', '')
> msg = ". {} .. '{}' .. {} .".format(a, path, b)
> Is there a better way?
This works for me:
>>> a = "spam"
>>> b = "ham"
>>> path = r"C:\a\b\c\d\e.txt"
>>> msg = ". %
On 4/15/2012 5:07 PM, Kiuhnm wrote:
This is the behavior I need:
path = path.replace('\\', '')
Is there a better way?
For one-time use, and given that you cannot un-double with the r prefix,
not that I know of. For using the substrings multiple times, name them.
>>> s = r'abc\cd\ef'
>>>
On Apr 15, 2:07 pm, Kiuhnm wrote:
> This is the behavior I need:
> path = path.replace('\\', '')
> msg = ". {} .. '{}' .. {} .".format(a, path, b)
> Is there a better way?
>
A little more context would help. The quadruple-toothpick idiom
predates Python. It's a little hard on the
On Sat, Apr 7, 2012 at 3:36 PM, Nobody wrote:
> The delimiter can be chosen either by analysing the string
> or by choosing something a string at random and relying upon a collision
> being statistically improbable.
The same techniques being available to MIME multi-part encoders, and
for the same
On Fri, 06 Apr 2012 06:22:13 -0700, rusi wrote:
> But are not such cases rare?
They exist, therefore they have to be supported somehow.
> For example code such as:
> print '"'
> print str(something)
> print '"'
>
> could better be written as
> print '"%s"' % str(something)
Not if the text betw
06.04.12 16:22, rusi написав(ла):
Yes. I hand it to you that I missed the case of explicitly unbalanced
strings.
But are not such cases rare?
No, unfortunately. }:-(
For example code such as:
print '"'
print str(something)
print '"'
could better be written as
print '"%s"' % str(something)
06.04.12 08:28, rusi написав(ла):
All this mess would vanish if the string-literal-starter and ender
were different.
[You dont need to escape a open-paren in a lisp sexp]
But you need to escape an escape symbol.
--
http://mail.python.org/mailman/listinfo/python-list
On Apr 6, 1:52 pm, Nobody wrote:
> On Thu, 05 Apr 2012 22:28:19 -0700, rusi wrote:
> > All this mess would vanish if the string-literal-starter and ender
> > were different.
>
> You still need an escape character in order to be able to embed an
> unbalanced end character.
>
> Tcl and PostScript us
On Thu, 05 Apr 2012 22:28:19 -0700, rusi wrote:
> All this mess would vanish if the string-literal-starter and ender
> were different.
You still need an escape character in order to be able to embed an
unbalanced end character.
Tcl and PostScript use mirrored string delimiters (braces for Tcl,
p
On Apr 6, 10:13 am, Steve Howell wrote:
> On Apr 5, 9:59 pm, rusi wrote:
>
> > On Apr 6, 6:56 am, Steve Howell wrote:
>
> > > One of the biggest nuisances for programmers, just beneath date/time
> > > APIs in the pantheon of annoyances, is that we are constantly dealing
> > > with escaping/encod
On Apr 5, 9:59 pm, rusi wrote:
> On Apr 6, 6:56 am, Steve Howell wrote:
>
> > One of the biggest nuisances for programmers, just beneath date/time
> > APIs in the pantheon of annoyances, is that we are constantly dealing
> > with escaping/encoding/formatting issues.
>
> [OT for this list]
> If yo
On Apr 5, 9:59 pm, rusi wrote:
> On Apr 6, 6:56 am, Steve Howell wrote:
>
> > One of the biggest nuisances for programmers, just beneath date/time
> > APIs in the pantheon of annoyances, is that we are constantly dealing
> > with escaping/encoding/formatting issues.
>
> [OT for this list]
> If yo
On Apr 6, 6:56 am, Steve Howell wrote:
> One of the biggest nuisances for programmers, just beneath date/time
> APIs in the pantheon of annoyances, is that we are constantly dealing
> with escaping/encoding/formatting issues.
[OT for this list]
If you run
$ find /usr/share/emacs/23.3/lisp/ -name
Kamil Wasilewski wrote:
Hi,
Ive got an issue where a variable name needs to have a minus sign (-) in it.
#Python 2.6
from SOAPpy import WSDL
wsdlFile = "http://webapi.allegro.pl/uploader.php?wsdl";
server = WSDL.Proxy(wsdlFile)
server.soapproxy.config.argsOrdering = {'doGetCountries': ['country
Nobody writes:
> On Wed, 29 Jul 2009 09:29:55 -0400, J Kenneth King wrote:
>
>> I wrote a script to process some files using another program. One thing
>> I noticed was that both os.listdir() and os.path.walk() will return
>> unescaped file names (ie: "My File With Spaces & Stuff" instead of "My
On Wed, 29 Jul 2009 09:29:55 -0400, J Kenneth King wrote:
> I wrote a script to process some files using another program. One thing
> I noticed was that both os.listdir() and os.path.walk() will return
> unescaped file names (ie: "My File With Spaces & Stuff" instead of "My\
> File\ With\ Spaces\
J Kenneth King wrote:
I wrote a script to process some files using another program. One thing
I noticed was that both os.listdir() and os.path.walk() will return
unescaped file names (ie: "My File With Spaces & Stuff" instead of "My\
File\ With\ Spaces\ \&\ Stuff"). I haven't had much success f
J Kenneth King wrote:
I wrote a script to process some files using another program. One thing
I noticed was that both os.listdir() and os.path.walk() will return
unescaped file names (ie: "My File With Spaces & Stuff" instead of "My\
File\ With\ Spaces\ \&\ Stuff"). I haven't had much success f
MRAB wrote:
> someone wrote:
>> Hi,
>>
>> as you can see below I have some optional parameter for my query (mf,
>> age). They are in WHERE clause only if not empty.
>> In this function they are not escaped as, for example, 'search'
>> parameter, cause I can't pass them to execute function, which do
On Mar 23, 1:48 pm, MRAB wrote:
> someone wrote:
> > Hi,
>
> > as you can see below I have some optional parameter for my query (mf,
> > age). They are in WHERE clause only if not empty.
> > In this function they are not escaped as, for example, 'search'
> > parameter, cause I can't pass them to e
ah, sorry, from title i guess you were aware of this. andrew
andrew cooke wrote:
> note that your version is open to sql injection attacks, while mrab's
> reply isn't. andrew
>
> someone wrote:
>> if mf:
>> mf = " AND mf = %s " % mf
>> if age:
>> age = "
note that your version is open to sql injection attacks, while mrab's
reply isn't. andrew
someone wrote:
> if mf:
> mf = " AND mf = %s " % mf
> if age:
> age = " AND age = %s " % age
--
http://mail.python.org/mailman/listinfo/python-list
someone wrote:
Hi,
as you can see below I have some optional parameter for my query (mf,
age). They are in WHERE clause only if not empty.
In this function they are not escaped as, for example, 'search'
parameter, cause I can't pass them to execute function, which does
escaping automatically.
I
Jean-Paul Calderone wrote:
> On Wed, 11 Feb 2009 09:31:56 -0600, Nick Craig-Wood
> wrote:
> >r0g wrote:
> >> I'm writing a linux remastering script in python where I need to chroot
> >> into a folder, run some system commands and then come out and do some
> >> tidying up, un-mounting proc &
1 - 100 of 137 matches
Mail list logo
