Á¬½Ómysql ΪʲôִÐвéѯ ½á¹û¼¯È´ÀÏûÓÐÄØ

C/C++ code:
UINT WINAPI CTEST::_ThreadTransData(LPVOID pParam)
{
CTEST&p=*(CTEST*)pParam;

while(!p.m_bExit)
{

CString strSQL;
strSQL.Format("select *¡¡from data as da where da.cid >%d order by timestamp, da.cid;",
p.m_TransferSCN);

if(mysql_master_query(&p.mysql, strSQL, strSQL.GetLength())!=0)
{
AfxMessageBox("Êý¾Ý¿âÖбí¸ñ³ö´í");
}

MYSQL_RES *result;
MYSQL_ROW row;

if(!(result=mysql_use_result(&p.mysql)))
{
AfxMessageBox("¶ÁÈ¡Êý¾Ý¼¯Ê§°Ü");
}

int i = 0;
CString sID, timestamp, srcip, srcport, dstip, dstport, data;

while(row=mysql_fetch_row(result))
{
sID.Format("%s", row[0]);
timestamp.Format("%s", row[1]);
srcip.Format("%s", row[2]);
srcport.Format("%s", row[3]);
dstip.Format("%s", row[4]);
dstport.Format("%s", row[5]);
data.Format("%s", row[6]);

//²åÈëµ½oracle
CString ssQuery;
ssQuery.Format("INSERT INTO datatemp \
(SCN, TIMESTAMP, SRCIP, SRCP