上海期货回调函数OnRtnDepthMarketData数据插入mysql的时候报错

OnRtnDepthMarketData在执行上面一句43个字段的时候31条数据数据插入到mysql的时候报错
而执行下面一段插入一个字段的时候正常插入268条记录，源码如下：void CMdSpi::OnRtnDepthMarketData(CThostFtdcDepthMarketDataField *pDepthMarketData)
{
int t;
memset(cmd, 0, sizeof(cmd));
#if 1
sprintf(cmd, "insert into t_depth_et_data values(\'%s\', \'%s\', \'%s\', \'%s\', %f, %f, %f, %f, %f, %f, \
 %f, %d, %f, %f, %f, %f, %f, %f, %f, %f, \'%s\', %d, %f, %d, %f, %d, %f, %d, %f, %d,   \
 %f, %d, %f, %d, %f, %d, %f, %d, %f, %d, %f, %d, %f)",
pDepthMarketData->TradingDay,
 pDepthMarketData->InstrumentID, pDepthMarketData->ExchangeID,pDepthMarketData->ExchangeInstID,
 pDepthMarketData->LastPrice, pDepthMarketData->PreSettlementPrice, pDepthMarketData->PreClosePrice,
 pDepthMarketData->PreOpenInterest, pDepthMarketData->OpenPrice, pDepthMarketData->HighestPrice,
 pDepthMarketData->LowestPrice, pDepthMarketData->Volume,pDepthMarketData->Turnover,pDepthMarketData->OpenInterest,
 pDepthMarketData->ClosePrice,pDepthMarketData->SettlementPrice,pDepthMarketData->UpperLimitPrice,
 pDepthMarketData->LowerLimitPrice,pDepthMarketData->PreDelta,pDepthMarketData->CurrDelta,
 pDepthMarketData->UpdateMillisec,pDepthMarketData->BidPrice1,
 pDepthMarketData->BidVolume1,pDepthMarketData->AskPrice1,pDepthMarketData->AskVolume1,
 pDepthMarketData->BidPrice2,pDepthMarketData->BidVolume2,pDepthMarketData->AskPrice2,
 pDepthMarketData->AskVolume2,pDepthMarketData->BidPrice3,pDepthMarketData->BidVolume3,
 pDepthMarketData->AskPrice3,pDepthMarketData->AskVolume3,pDepthMarketData->BidPrice4,
 pDepthMarketData->BidVolume4,pDepthMarketData->AskPrice4,pDepthMarketData->AskVolume4,
 pDepthMarketData->BidPrice5,pDepthMarketData->BidVolume5,pDepthMarketData->AskPrice5,
 pDepthMarketData->AskVolume5,pDepthMarketData->AveragePrice);
#else
sprintf(cmd, "insert into t_depth_et_data(TradingDay) values(\'%s\')",pDepthMarketData->TradingDay);
#endif t = mysql_real_query(&mysql, cmd, strlen(cmd)); 
if (t) 
{    
printf("Error making query: %s\n", mysql_error(&mysql)); 
} 
else 
{  
printf("TradingDay:%s\t",pDepthMarketData->TradingDay);
printf("insert success...\n");
}
}