sql INSERT ÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

pCmd->CommandText="insert into userftprequest(filename,telnoid,telno,indatetime,productid,dealdatetime,activedatetime,canceldatetime,doflag) values( '"+file_name+"','"+telnoid+"','"+telno+"',todate('"+indatetime+"','YYYY-MM-DD HH24:MI:SS'),'"+productid+"',todate('"+dealdatetime+"','YYYY-MM-DD HH24:MI:SS'),todate('"+activedatetime+"','YYYY-MM-DD HH24:MI:SS'), todate('"+canceldatetime+"','YYYY-MM-DD HH24:MI:SS'),'"+doflag+"')";
ÕâÀﱨ´í
error C2678: ¶þ½øÖÆ¡°+¡± : ûÓÐÕÒµ½½ÓÊÜ¡°std::basic_string<_Elem,_Traits,_Ax>¡±ÀàÐ͵Ä×ó²Ù×÷ÊýµÄÔËËã·û(»òûÓпɽÓÊܵÄת»»

---

-- ºÜÂÒ£¬Ã»·¨¿´!

---

´òÓ¡ÏÂÕâ¸ö×Ö·û´®pCmd->CommandText £¬ÔÚPLSQLÖпÉÒÔÖ´ÐÐÂð£¿

---

±¨´í ²»ÄÜÖ´ÐдòÓ¡

---

insert into userftprequest(filename,telnoid,telno,indatetime,productid,dealdatetime,activedatetime,canceldatetime,doflag£©
values( '"+file_name+"','"+telnoid+"','"+telno+"',
todate('"+indatetime+"','YYYY-MM-DD HH24:MI:SS'),
'"+productid+"',todate('"+dealdatetime+"','YYYY-MM-DD HH24:MI:SS'),
todate('"+activedatetime+"','YYYY-MM-DD HH24:MI:SS'), 
todate('"+canceldatetime+"','YYYY-MM-DD HH24:MI:SS'),'"+doflag+"')";
Õâ²»»áºÜÂÒ°É
°ïæ¿´ÏÂÁË Ð»Ð»

---

todate('"+canceldatetime+"','YYYY-MM-DD HH24:MI:SS'),'"