Sep-20-2018, 02:07 PM
Guys, I am new to Python and would like to ask for assistance.
I am busy with a database using forms.
One of the things I have is a button on the form, basically giving me data in a table specified by a specific word.
The code for this is :
I read online and tried all the examples, nothing works, either I get a blank sheet back or the same "single" specified word data as it normally will and or an error.
I tried the example code as I gave it here and added the AND and the OR many different ways but still no luck, please assist!!
I am busy with a database using forms.
One of the things I have is a button on the form, basically giving me data in a table specified by a specific word.
The code for this is :
cursor.execute("SELECT * FROM `stock` WHERE `stock_location` LIKE '%Not%'") Works fine, gives me the data I want, problem is I want another word inclujded in the data output.I read online and tried all the examples, nothing works, either I get a blank sheet back or the same "single" specified word data as it normally will and or an error.
I tried the example code as I gave it here and added the AND and the OR many different ways but still no luck, please assist!!