CDatabase db;
BOOL bRet = db.Open(NULL, FALSE, FALSE, _T("ODBC;DSN=Gface;UID=root;PWD="));
if(!bRet)
{
return S_FALSE;
}
CString cmdStr;
cmdStr.Format(_T("SELECT t.ID,\
t.USERID,\
t.FEALEN,\
t.FEA,\
t.IMGURL,\
t.TYPE1,\
t.TYPE2,\
t.TYPE3,\
t.TYPE4,\
t.STAMP,\
t.REMARKS \
FROM T_FACE t WHERE t.ID > %llu and (t.ISDEL is null or t.ISDEL = 0) order by t.ID"),nID);
CRecordset rs( &db );
bRet = rs.Open( CRecordset::forwardOnly, (L"%s", cmdStr));
if(!bRet)
{
db.Close();
return S_FALSE;
}
while(!rs.IsEOF())
{
FACE_INFO info;
CString valueID;