Select with pyodbc

Question

Select with pyodbc

Navigation

#1 by (0 votes)

0

I'm trying to use the string I get from an Entry and an OptionMenu to perform the search on SqlServer but gives the following error:

TypeError: not enough arguments for format string

Here is the function code that executes the call:

def checkin(self):
    veri = self.cur.execute("select %s.id_aluno "
                            "from alunos,%s"
                            " where %s.id_aluno = alunos.matricula" % self.variavel.get() % self.variavel.get() % self.variavel.get() )
    print(veri)

sql python select pyodbc

asked by anonymous 18.04.2018 / 21:38

1 answer

Problems with sonar module HCSR04 Fluid Layout with Sidebar Fixed, and theiaStickySidebar

score 0 · Accepted Answer

You should only use % after the string and pass a tuple:

def checkin(self):
    veri = self.cur.execute("select %s.id_aluno "
                            "from alunos,%s"
                            " where %s.id_aluno = alunos.matricula" % (self.variavel.get(), self.variavel.get(), self.variavel.get()) )
    print(veri)