Selection based ob variables issue
vergos.nikolas at gmail.com
vergos.nikolas at gmail.com
Sat Feb 2 00:57:35 EST 2019
Hello, iam tryting to execute mysql queries based on python variables.
name = request.args.get('name')
month = request.args.get('month')
year = request.args.get('year')
try:
if '=' not in name + month + year:
cur.execute( '''SELECT * FROM jobs WHERE clientID = (SELECT id FROM clients WHERE name = %s) and MONTH(lastvisit) = %s and YEAR(lastvisit) = %s ORDER BY lastvisit DESC''', (name, month, year) )
elif '=' not in name + year:
cur.execute( '''SELECT * FROM jobs WHERE clientID = (SELECT id FROM clients WHERE name = %s) and YEAR(lastvisit) = %s ORDER BY lastvisit DESC''', (name, year) )
elif '=' not in month + year:
cur.execute( '''SELECT * FROM jobs WHERE MONTH(lastvisit) = %s and YEAR(lastvisit) = %s ORDER BY lastvisit DESC''', (month, year) )
elif '=' not in year:
cur.execute( '''SELECT * FROM jobs WHERE YEAR(lastvisit) = %s ORDER BY lastvisit ASC''', year )
else:
Problem is that only the first clause works as expected and not the rest.
'=' means variables contains no value.
How can i make it work?
More information about the Python-list
mailing list