git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Selection based ob variables issue


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?