Re: cur.execute() syntax error [RESOLVED]

On Mon, 4 Apr 2022, Christophe Pettus wrote:

> It looks like the LabelInput constructor includes some code. Did you mean something like:
>
> self.inputs['Contact Type'] = LabelInput(
> ContactDataForm, 'contact_type',)
> # query to fetch data from contacttypes table
> fetch_all = "SELECT * from contacttypes"
> cur.execute(fetch_all)
> # fetching all rows
> rows = cur.fetchall()
> input_class=ttk.Combobox([values = rows])
> input_var=tk.StringVar()
> # get selected value and bind it to a method
> cont_type = self.get() # selected value by mouse click
> con.close()

Christophe,

Sure looks like it.

Thanks,

Rich