sqlTxt = '''
select *
from table_a
where staff_no = ${staff_no}
'''
results =self.myDb.query(sqlTxt, vars={'staff_no':staff_no})
rs = results.i.gi_frame.f_locals["names"]
sqlTxt = '''
select *
from table_a
where staff_no = ${staff_no}
'''
results =self.myDb.query(sqlTxt, vars={'staff_no':staff_no})
rs = results.i.gi_frame.f_locals["names"]