Mar-21-2019, 01:50 AM
Removing the curly bracjet when it inserted the data was resolved by a small change to 2 lins in each query segment of the code.
Removing the [0] in line 3 and 6 was required. The same was true for each query there after in that segment of code.
Removing the [0] in line 3 and 6 was required. The same was true for each query there after in that segment of code.
try: dish_type_entry.delete(0,END) index = output.curselection()[0] selected = output.get(index) c.execute('SELECT Dish_Type FROM Recipes WHERE Recipe = :selected', {'selected': selected[0]}) dish_type_result = c.fetchone() dish_type_entry.insert(0,dish_type_result[0]) recipe_entry.delete(0,END) index = output.curselection()[0] selected = output.get(index) c.execute('SELECT Recipe FROM Recipes WHERE Recipe = :selected', {'selected': selected[0]}) recipe_result = c.fetchone() recipe_entry.insert(0,recipe_result[0]) serves_entry.delete(0,END) index = output.curselection()[0] selected = output.get(index) c.execute('SELECT Serves FROM Recipes WHERE Recipe = :selected', {'selected': selected[0]}) serves_result = c.fetchone() serves_entry.insert(0,serves_result[0]) cook_time_entry.delete(0,END) index = output.curselection()[0] selected = output.get(index) c.execute('SELECT Cook_Time FROM Recipes WHERE Recipe = :selected', {'selected': selected[0]}) cook_time_result = c.fetchone() cook_time_entry.insert(0,cook_time_result[0]) index = output.curselection()[0] selected = output.get(index) c.execute('SELECT Ingredients FROM Recipes WHERE Recipe = :selected', {'selected': selected[0]}) ingredients_result = c.fetchone() ingred.insert(1.0,ingredients_result[0]) ingred.config(wrap=WORD) index = output.curselection()[0] selected = output.get(index) c.execute('SELECT Instructions FROM Recipes WHERE Recipe = :selected', {'selected': selected[0]}) instructions_result = c.fetchone() instruct.insert(1.0, instructions_result[0]) instruct.config(wrap=WORD) except: messagebox.showerror('DataBase Error', 'Failed to load category')The resolved code is:
try: dish_type_entry.delete(0,END) index = output.curselection() selected = output.get(index) c.execute('SELECT Dish_Type FROM Recipes WHERE Recipe = :selected', {'selected': selected}) dish_type_result = c.fetchone() dish_type_entry.insert(0,dish_type_result[0]) recipe_entry.delete(0,END) index = output.curselection() selected = output.get(index) c.execute('SELECT Recipe FROM Recipes WHERE Recipe = :selected', {'selected': selected}) recipe_result = c.fetchone() recipe_entry.insert(0,recipe_result[0]) serves_entry.delete(0,END) index = output.curselection() selected = output.get(index) c.execute('SELECT Serves FROM Recipes WHERE Recipe = :selected', {'selected': selected}) serves_result = c.fetchone() serves_entry.insert(0,serves_result[0]) cook_time_entry.delete(0,END) index = output.curselection() selected = output.get(index) c.execute('SELECT Cook_Time FROM Recipes WHERE Recipe = :selected', {'selected': selected}) cook_time_result = c.fetchone() cook_time_entry.insert(0,cook_time_result[0]) index = output.curselection() selected = output.get(index) c.execute('SELECT Ingredients FROM Recipes WHERE Recipe = :selected', {'selected': selected}) ingredients_result = c.fetchone() ingred.insert(1.0,ingredients_result[0]) ingred.config(wrap=WORD) index = output.curselection() selected = output.get(index) c.execute('SELECT Instructions FROM Recipes WHERE Recipe = :selected', {'selected': selected}) instructions_result = c.fetchone() instruct.insert(1.0, instructions_result[0]) instruct.config(wrap=WORD) except: messagebox.showerror('DataBase Error', 'Failed to load category')
"Often stumped... But never defeated."