passwd -u
我想选择set <string> extensionsSet;
std::ofstream fos(target,ios::binary);
Poco::Zip::Compress c(fos,true);
extensionsSet.insert("txt");
c.setStoreExtensions(extensionsSet);//set extensions List
set <string> a = c.getStoreExtensions();//a contains 1 string which is txt
Poco::File aFile(source);
if (aFile.exists())
{
if (aFile.isDirectory())
{
Poco::Path sourceDir(source);
sourceDir.makeDirectory();
c.addRecursive(sourceDir,Poco::Zip::ZipCommon::Compressionmethod::CM_DEflaTE,Poco::Zip::ZipCommon::CL_NORMAL,false);
}
else if (aFile.isFile())
{
Poco::Path p(aFile.path());
c.addFile(p,p.getFileName(),Poco::Zip::ZipCommon::Compressionmethod::CM_AUTO,Poco::Zip::ZipCommon::CL_NORMAL);
}
}
else {
_log.EndMethod();
throw new FileNotFoundException("File Not Found");
}
c.close(); // MUST be done to finalize the Zip file
fos.close();
作为select stdcode,name,degree_code,phone,startsemester,endsemester
from (
select distinct stdcode as stdcode,name as name,degree_code as degree_code,phone as phone,(
SELECT sem_code
FROM V_ALLSTUDATA b
WHERE a.name = b.name
and a.stdcode= b.stdcode
and a.degree_code=b.degree_code
and a.phone=b.phone
AND startsem=(select min(startsem)
from V_ALLSTUDATA b)
) as startsemester,(
SELECT sem_code
FROM V_ALLSTUDATA b
WHERE a.name = b.name
and a.stdcode= b.stdcode
and a.degree_code=b.degree_code
and a.phone=b.phone
AND startsem=(select
max(startsem) from V_ALLSTUDATA a)
) as endsemester
from V_ALLSTUDATA a
);
和sem_code
作为startsem_code
如何解决此错误?
ORA-01427:单行子查询返回多个行
01427. 00000-“单行子查询返回多个行”
*原因:
*动作: