Re: cur.execute() syntax error [RESOLVED] - Mailing list psycopg

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