i have a problem getting some records from the data base of a biometric, it's a biostar suprema, i have the next code to connect from a python program.
cursor.execute("SELECT t1.USRID, SRVDT, DEVUID, EVTLGUID, EVT, NM, t1.USRGRUID, USRUID, date(SRVDT), WEEK(SRVDT, 0) AS SEMANA, TIME(SRVDT), DRUID , date(STTDT) FROM biostar2_ac.t_lg"+str(aniomes2)+" t1 INNER JOIN biostar2_ac.t_usr t2 ON t1.USRID = t2.USRID WHERE ( date(SRVDT) BETWEEN "+str(aniomes2)+firstDay+" AND "+str(aniomes2)+fecha2+" ) ORDER BY USRGRUID, USRUID, SRVDT, EVTLGUID")
And the problem is that a record has some missing data when i try to get it from my program but if i search the record in the biostar webapp the record is complete.
i didn't created the database it's seems like it comes from default with the biometric system, i don't know if there is a hidden database and the database i'm getting into is copy of the main database, i look for the record in the database i'm using in my program but it's doesn't appear, so, there's nothing wrong in the code, i suspect that there is another database or instance that the webapp is consulting.