I have a question for Python if.

per1="25"
per2  = ".75"
if row[23] == 'sale1' or row[23] == 'sale2':
    if row[27].find(per1) == -1:
        cursor.execute(sql)
else:
    cursor.execute(sql)

Or 

per2  = ".75"
if row[23] == 'sale1' or row[23] == 'sale2':
    if row[27].find(per2) == -1:
        cursor.execute(sql)
else:
    cursor.execute(sql)


If I do this, it'll be filtered properly 

per1 = ".25"
per2  = ".75"
if row[23] == 'sale1' or row[23] == 'sale2':
    if row[27].find(per1) == -1 and row[27].find(per2) == -1:
        cursor.execute(sql)
else:
    cursor.execute(sql)
In this case, it doesn't filter at all.
Why is that?

python if-else find

2022-09-21 14:16

1 Answers

per1 = ".25"
per2  = ".75"
if row[23] == 'sale1' or row[23] == 'sale2':
    if row[27].find(per1) == -1 or row[27].find(per2) == -1:
        cursor.execute(sql)
else:
    cursor.execute(sql)

Change "and" to "or".

2022-09-21 14:16

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656