A certainl part of an if() structure never gets executed.

[MRAB]

On 12/06/2013 12:17, Νικόλαος Κούρας wrote:
>
>> As with most of your problems you are barking up the wrong tree.
>> Why not use the actual value you get from the form to check whether you
>> have a valid month?
>> Do you understand why "0" is submitted instead of "=========="?
>>
>> Bye, Andreas
>
> I have corrected the enumerate loop but it seems thet now the year works
> and the selected name nad month fail:
>
> 		if '=' not in ( name and month and year ):
> 			cur.execute( '''SELECT * FROM works WHERE clientsID = (SELECT id FROM
> clients WHERE name = %s) and MONTH(lastvisit) = %s and YEAR(lastvisit) =
> %s ORDER BY lastvisit ASC''', (name, month, year) )
> 		elif '=' not in ( month and year ):
> 			cur.execute( '''SELECT * FROM works WHERE MONTH(lastvisit) = %s and
> YEAR(lastvisit) = %s ORDER BY lastvisit ASC''', (month, year) )
> 		elif '=' not in year:
> 			cur.execute( '''SELECT * FROM works WHERE YEAR(lastvisit) = %s ORDER
> BY lastvisit ASC''', year )
> 		else:
> 			print( '<h2><font color=red>Πώς να γίνει αναζήτηση αφού δεν επέλεξες
> ούτε πελάτη ούτε μήνα ή τουλάχιστον το έτος?' )
> 			print( '<meta http-equiv="REFRESH"
> content="5;/cgi-bin/pelatologio.py">' )
> 			sys.exit(0)
>
>
> i tried in , not in and all possible combinations. but somehow it
> confuses me.
>
> doesn't that mean?
>
> 		if '=' not in ( name and month and year ):
>
> if '=' does not exists as a char inside the name and month and year
> variables?
>
> i think it does, but why it fails then?
>
You think it does, but you're wrong.